Manual page 79 says lookups to Q&A 5.0 DTF files is possible, but I'm having trouble crafting a programming statement that works. This is what I have:
My Sesame database is Employee.db with a single form, Employee. It has a le SS which contains a Social Security Number, and a le License which is currently empty. Both are formatted as text.
My external database is located in the same folder as Employee.db. It is DRIVERS.DTF. It contains a field named SS and a field named LICENSE.
I'm trying to have Sesame look up a record based on matching Social Security Numbers, retreive the license info from LICENSE and place it in License.
The XLookup statement as it stands (not working):
Xlookup("drivers.dtf",SS,"SS","LICENSE",License)
This has been placed in License's "on-element-entry" section.
I'm probably overlooking some kind of protocol. Help would be appreciated.