Normal Topic using XLookup (Read 583 times)
FSGROUP
Full Member
***
Offline


No personal text

Posts: 179
Location: Edmonton, Alberta, Canada
Joined: Jan 14th, 2004
using XLookup
Jan 19th, 2004 at 10:14pm
Print Post Print Post  
hi,

i have two databases in a .dsr file, say they are named A and B.  I am trying to read values from database A into database B where A!Id=B!Id.  I tried using Xlookup, but I cannot seem to retrieve data from A.  Am I doing something wrong?

thanx
  
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: using XLookup
Reply #1 - Jan 19th, 2004 at 10:49pm
Print Post Print Post  
First of all remember that you cannot test the x-family command in "Preview Application".  You either need to save as different application or merge with the existing application to test it.

Since it is the same application, the application name will be @fn,  say you are trying to look up Name from database A while working with database B.  the form name is Main in A database

Database A:

id:                 Name:

******************
Database  B:

id:                NewName:

syntax will be:

NewName = @xlookup (@fn, id, "Main!id", "Name")


  
Back to top
 
IP Logged