AnsweredAssumed Answered

How to set donot create duplicate customer if record exists in invoice

Question asked by AmjadMiandad on Mar 10, 2015
Latest reply on Mar 11, 2015 by AmjadMiandad

Title

How to set donot create duplicate customer if record exists in invoice

Post

Hi all,

I am working on a pizza shop database Im using Filemaker Pro Advance 12.

I have create these tables

Company info

Client Details

Product Menu

Invoices

Invoice Data

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)

 

Outcomes