Anne has attended:
Access Introduction course
Access
I am in the process of creating a database and need to split the tables I am creating - how do you suggest I do this? Do I need to create the main database and then a table with the financial information and another table with the contacts and so forth
RE: 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
