table design question

[Choksy]

I have many account numbers in my other table and i want to have a system where account numbers can relate to one customer..how can i do this?

 

[Mile-O]

Can one customer have more than one account or can one customer only have one account?

You need to be more specific.

 

[Choksy]

re

a customer can have more than one account.

 

[Kevin_S]

two tables:

tblCustomers :
CustID (Primary Key)
FName
LName
etc...

tblAccounts :
AcctID (Primary Key)
CustID (Foreign Key)
AcctData
etc...

Relationships :
1 - many join between tblCustomers and tblAccounts set between the CustID fields

*make sure you check referential intergrety and set cascade update and delete (so you wont have account records without customers)

HTH,
Kev

 

[Mile-O]

The question's ongoing in the Tables forum in a lot more detail.

 

[Kevin_S]

Ahh... I just love double posts that waste my time

Thanks for letting me know Mile so I didn't waste more time...

Kev

Edit* for those interested he is the link to the other post:
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=55657