Normal Topic XLU and merged application (Read 454 times)
PeterG
Member
*
Offline


No personal text

Posts: 11
Joined: Jan 19th, 2004
XLU and merged application
Feb 23rd, 2004 at 1:34am
Print Post Print Post  
I have two applications, Customer.db and Sales.db.  In Sales.db there are XLU commands which retrieve data from data\Customer.db.  After I merge the Customer.db into Sales.db, don't I want those lookup commands to begin retrieving the data from the Customer database in the Sales application (and no longer from data\Customer.db) because additions and updates to the merged Customer database in the Sales application don't show up in data\Customer.db?  How do I structure the XLU command to get the data from a database within the same application?  I've tried using @fn but must be doing something wrong.  Thanks.
  
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: XLU and merged application
Reply #1 - Feb 23rd, 2004 at 3:01am
Print Post Print Post  
In the database name you have to have @fn or @filename. Now you have multiple forms in the database, so you also have to  include the name of the form. e.g.

Name = @xlookup (@fn, RecNumber, "Customer!RecNumber", "Name")

Customer is the name of the form.

  
Back to top
 
IP Logged