AnsweredAssumed Answered

Two suburbs in one customer record

Question asked by lexpharm on Jun 11, 2018
Latest reply on Jun 13, 2018 by lexpharm

I am trying to create a customer file which contains two addresses, one residential and one postal. Following the advice that no piece of data should be entered twice, I have created tables State, Postcode, Suburb, Customer, with a one to many from State to Postcode, Postcode to Suburb, Suburb to Customer.

I am perplexed as to how to get the second address into the Customer layout. Any help would be appreciated. I am returning to Filemaker after a long absence.