Setting up fields

[Jess]

I am attempting to create my first database for my job and
I have run into my first problem. In the database there
should be a field that includes the client's account
number, however most clients have more than one account
number, and some clients have the same account number.

How do I:

1. Create a field where more than one account number can
be entered.

2. The account numbers can be designated duplicates or not
(preferably a check box)

 

[Kevin3NF]

"however most clients have more than one account number"
This I get....

" and some clients have the same account number"
Is this intentional? Is account number even relevant?

The answers to these will go a long way towards helping with your table
design

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[John Vinson]

I am attempting to create my first database for my job and
I have run into my first problem. In the database there
should be a field that includes the client's account
number, however most clients have more than one account
number, and some clients have the same account number.

How do I:

1. Create a field where more than one account number can
be entered.

2. The account numbers can be designated duplicates or not
(preferably a check box)

You will need *THREE* tables, not one. Access is a relational
database; this means (among other things) that a field should have one
and only one value.

You'll need a table of Clients; a table of Accounts; and a third table
to contain the many to many relationship between these tables -
ClientAccounts. It would have fields for the ClientID (but no other
client information) and the AccountNumber (but no other account
information).