Access

Hi Anne,

Thank you for your question and welcome to the forum.

I understand from your email that you have one table with all the financial and contact details.

What you need to do is create two separate tables, one that contains the Financial fields and one with all the Contact details. Each table should have a Primary Key that uniquely identifies each record in each table such as FinanceID and ContactID.

If a contact had more than one financial record or product, thern you need to put a Foreign key in the Financial table.

Then you link the Primary key in the Contacts table to the Foreign key in the Financial table. You usually name the Foreign Key the same name as the Primary key in the other table.

I hope this helps.

Regards

Simon