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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
