Hi,
The system I was working on had 2 separate applications, with 2 seperate databases (orders and clients). I realized that there was no reason for them to be separated so I merged them into the same app. It worked but not I have a question about re-doing the XLOOKUP commands.

The old app would use XLOOKUP to pull in client data based on the account #.
for example:
COMPANY ORDERING= @XLOOKUP("D:\Sesame Data\clients.db",ACCT #,"ACCT #","COMPANY")

But now that the clientdb is in the same app as the order db, how would I rewrite this part? Is an Xlookup even needed since they're already together?

thanks,
D

Thanks. I thought there was a command that would do  the lookup without DB reloading. I used your suggestion and it worked.

D