Client Table

  • Thread starter Thread starter Mary Soley
  • Start date Start date
NOT one Table!

You need at least 3 or more Tables: 1 for Client details (without address
details), 1 for Addresses and one for Reps.

Each Table should only store details / properties of ONE type of entity.
From your short description, you already have 3 different entities.

You can then relate these Tables with appropriate relationships. My guess
is that you will need One-to-Many between Clients and Addresses and
Many-to-Many relationship between Clients and Reps.

Perhaps, you should check out the Relational Database Design Theory and
design your Table Structure *before* implement this in an Access database.
 
Back
Top