Got 2 questions...

1) I have converted two databases that we currently use.  The first one "BuilderCodes" had no programing and was done perfectly.  The only thing I noticed is the date format is yyyy/mm/dd.  How can I change this to mm/dd/yyyy?

2) The second database I converted was "Permits".  This database has xlookup statements to "BuilderCodes".  The databases right now are currently under seperate applications, and in the near future, I would like to merge them and some other db's to one application.  How does the syntax for xlookup work with a db in another application, what changes will need to be made when they are merged, and if what I've seen, just calls the db, do all field names in the application need to be unique or can two db's in one application have fields that are the same name.  ie field names are unique to the db, but not the application?

Thanks,
Duane

Still learning, but getting easier as the hours tick by!!!!

Duane,

I believe the fields are unique per database not per application.

It is my understanding that the xlookup uses the form name followed by a bang ! Symbol followed by the element name to specify the element you are working with.

So to clarify I think Sesame differentiates between 2 elements named FirstName in separate databases in the same application because one is formname1!FirstName and the other would be formname2!FirstName

I hope this is somewhat helpful.