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!