How to set donot create duplicate customer if record exists in invoice
I am working on a pizza shop database Im using Filemaker Pro Advance 12.
I have create these tables
I have used "Invoice data" as a portal in "Invoice" form and also using two fields from "Client Details" i.e. Client Name & Phone Number.
These 2 fields are storing data in lists for Client Name & Phone No. using in Client name & phone Number fields of table "Client Details"
1) What I want is when ever I enter client name if it exists it starts to auto fill from dropdown menu (It does that very well) and if the name exists it should auto enter its related phone number (here im failed to do).
2) Second thing doesn't matter how many times I enter client name "John Doe" with phone number "111222333" it creates a new client in client data but I want it to look if the same data exists in the list just display but not auto create with invoice.
Relations between "Invoices" and "Client Details" tables are
customer id match field = customer id match field
any suggestions where Im doing wrong for those two requirements (auto select phone number for contact name and not to create duplicates)