AnsweredAssumed Answered

Looking up keys

Question asked by blackgryphon on Jan 18, 2009
Latest reply on Jan 18, 2009 by Jens Teich

Title

Looking up keys

Post

I'm almost there :-D The global fields will do what I need for temporary data entry storage. Just one final (I hope) question. I need to do a lookup with the following format:

 

book::work number = work::work number WHERE book::author&title = work::author&title

 

The book and work tables are related by the work number. 

 

The Lookup function doesn't seem to have this functionality. This is a type of syntax that I'll need to use throughout the application. (Easy in SQL...)

 

Is there some way to do this? 

 

Thanks a million!

 

Jan 

Outcomes