Drop down menu
Using FileMaker Pro on a Mac.
In a Sales table there is a portal into LineItems table. A Drop-down List from Products table allows selection of items for new sales record.
After new sale is created a button takes you to LineItems table and searches for current Invoice ID. Message says "No records match this set of find request. Cancel, Continue, Modify Find.
If I view the LineItems table the invoice number is visible but a search for that number does not find any records.
I hope the problem is clear enough to understand.