can someone tell me where I go wrong becuase when I input instead of the info appearing the field goes blank? am still to used to Q&A but can't get my head around the xlookup functions with sesam  ???

I have two files
1.db
2.db

I need the info from 1.db to appear in 2.db
1.db has the following fields:
Number
Name
Adress

2db has
number
and I want name and adress to appear when I input the number.

this is the command string I have

element is number - upon form change

xlu ("1.db", number, "number", "name", name)


Please someone help me with this!

Have you tried using a full path to the lookup database? For example:

xlu ("C:\Sesame\Data\1.db", number, "number", "name", name)

Of course, replace: "C:\Sesame\Data\" with the actual path to your .db file.

To avoid having XLookup blank your field if it returns either a blank value or an error, use a variable:

var v_tmp as string

v_tmp = @xlu("C:\MyDir\MyDb.db", number, "number", "name")
if(v_tmp <> "")
{
   name = v_tmp
}