Will this require a script?
(I'm making this example simple.)
I have a table of customers.
I have a table of orders.
The tables are joined on a Customer ID key.
I want to create a customer from the orders table. So far, so good.
But when the customer calls for a second order, I want Filemaker to recognize that her phone number already exists and pull up her (formerly created) Customer ID. (so that I still only have one customer record instead of a duplicate with two different customer IDs.)