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.

It is, but I'll hard code the path anyway and try again.  Thanks.

I solved it; it was the template.  Although Q&Awas displaying the dashes it was not storing them, so Sesame could find no match.  I removed the dashed from both databases and the lookup works.  I'll use a mass update to put them back in later.