Title
Multi Criteria Lookup
Post
FileMaker Help mentions a "Multi-Criteria Lookup"... does this mean i can set up a lookup script that identifies a record in a separate table based on multiple fields and not just one? For example: Lookup (F1=AB,F2=BB,F3=BC) then lookup what appears in F4? Right now I am using a find/copy/paste script, but a lookup seems like it would be more efficient. Thanks.
There's no such thing as a "multi-criteria lookup" - but there can be a multi-criteria relationship (or more accurately, a multi-predicate relationship). So you can define your relationship as:
TableA::F1 = TableB::AB
AND
TableA::F2 = TableB::BB
AND
TableA::F3 = TableB::BC
then define another field in TableB to lookup from TableA::F4.