AnsweredAssumed Answered

Will this require a script?

Question asked by cheathamtech on Nov 8, 2009
Latest reply on Nov 9, 2009 by philmodjunk


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.)