I am trying to correct one of the design issues with an app I inherited. The original design did not contain a contacts table. As a result I have several fields in tables that are storing name, email and phone data. I created a Contacts table and a relationship to the Master table with the Contacts as the parent. But I cannot see how to use the data in the Contacts table to populate multiple sets of contact related fields.
I look forward to your suggestions.
------------------------------
Paul Peterson
------------------------------