cfgProj = ALLTRIM(THISFORM.Combo1.Value) &&DropDown value USE projects AGAIN in 0 alias prj order tag project &&Open lookup cfgProjPre = iif(; SEEK(cfgProj, "prj", "project"), ; ALLTRIM(project.prefix),; ???) &&Find Value&Set table prefix ? cfgProjPre &&ConfirmBut I think it's not assigning a value to cfgPorjPre. If the code is really typed as in your prg, here :
LOCAL nCurArea nCurArea = SELECT() && Store current area cfgProj = ALLTRIM(THISFORM.Combo1.Value) USE projects AGAIN &&Open lookup in same work area SET ORDER TO project SEEK cfgProj IF FOUND() cfgProjPre = ALLTRIM(prefix) ? cfgProjPre ENDIF SELECT(nCurArea) && Useless it would be "projects.dbf"So could you be losing your alias at entry ? If it's the case take care of opening a new table "use ... in 0" or "select 0 + use ...".