Does anyone see what I'm doing wrong here I get no errors but it returns nothing:

XLookup("data\tentreg.db",LE36,"tentreg!projapt","project",LE43)   :                           

'(

The LE36 element was added by sesame and bound to the work order form field "projapt", the LE43 is the element on my work order form to put the project into and is bound to the field project, does it have to be a unbound element to fetch a xlookup from another database?

Remember, X commands cannot be tested in "Preview Mode". You must reconcile and test them in Sesame "runtime" program.

ALso, I pasted below some tips that Erika gave me about using the correct field names in an xlookup.

Also, keep a close eye on your quotes used in those commands. I'm always getting in trouble with the quotes.

Hope this helps!
Steve

From Erika:
You should be using LE names, not field names. If the LE's have been deleted, Sesame will have no way of knowing what field they used to be bound to and, therefore, will not be able to get the data from that field. You cannot do X Commands on fields that have no LE's bound to them. The LE is the "window" on the field.

No problem. Happens to everyone!

Steve

Quote:


Ditch the quotes around @FN. With the quotes, Sesame is looking for an application with the literal filename "@FN". Without the quotes, it looks for the application returned by the builtin SBasic function @FN which returns the current filename.

You also should not put the form name on the last argument. It is assumed that the LE to be returned is on the same form as the LE to be matched.

Try something like:
LE43 = @XLOOKUP(@Fn, LE36, "tentreg!projapt", "project")

That worked Erika, Thanks