(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › xlookup Question
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic xlookup Question (Read 693 times)
jerry.frazier
Member
*
Offline


No personal text

Posts: 16
Location: Fort Worth, Texas
Joined: Feb 12th, 2004
xlookup Question
Feb 27th, 2004 at 4:00am
Print Post Print Post  
I have run searches and cannot find a exact match to my problem.  I have an application that contains more than one database.  I want to do a xlookup between two of the databases.  Here is what I am working with:
Application is Tracker
database!form doing the lookup is Trans and Form name is Trans.
Trans is doing a xlookup to database INV with a form name INV.
My latest try was
xlookup(@fn,StockNo,"Inv!Stock","make",make)

I am reconciling and testing in sesame not in preview.

Thanks for your help.  You all have been a great help.

Jerry Frazier
  
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: xlookup Question
Reply #1 - Feb 27th, 2004 at 10:42am
Print Post Print Post  
Quote:
Application is Tracker
database!form doing the lookup is Trans and Form name is Trans.
Trans is doing a xlookup to database INV with a form name INV.
My latest try was  
xlookup(@fn,StockNo,"Inv!Stock","make",make)



Everything look perfect to me. You just want to recheck the four elements' names, not just labels. What you generally see is the label, but what is referred here is the name.  Please recheck the underlying names of:

Trans!StockNo
Inv!Stock
Inv!make
Trans!Make

Also check one more thing as to the type of key fields. If StockNo is a Number field and Stock is a Text field, I believe it might interfere with proper lookup. Please let us know if you detect what made it not work, so we do not make the same mistake.
« Last Edit: Feb 27th, 2004 at 3:40pm by Bharat_Naik »  
Back to top
 
IP Logged
 
jerry.frazier
Member
*
Offline


No personal text

Posts: 16
Location: Fort Worth, Texas
Joined: Feb 12th, 2004
Re: xlookup Question
Reply #2 - Feb 29th, 2004 at 7:13pm
Print Post Print Post  
Sorry I did not get back sooner.  The code was correct.  I was concentrating on the XLookup and failed to notice that it was contained within an If statement.  Once the If statement was satisfied, it worked. 

Thanks for the assist.

Jerry Frazier
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge