4 Replies Latest reply on Mar 11, 2015 11:33 AM by AmjadMiandad

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

    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)