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.