AnsweredAssumed Answered

Looking up keys

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


Looking up keys


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!