relation ship

[sarab565]

hi,



i already create access database but i'm facing problem in one to many relationship if somebody can help me i will be happy

[Bob Fitz]

What is the problem?

[sarab565]

for example ...

i have five tables
table 1
table 2
table 3
table 4
table 5
and the link should be as the following
table 1 one to many table 2
table 2 one to many table 3
table 2 one to many table 4
table 2 one to many table 5

when i create the relationship it's says that there is problem in choosing the keys

[sarab565]

if you can help me i will send email which include the program and you can check it for me

[Bob Fitz]

If you attach a 2003 mdb version of your database to a post, I'm sure that someone will be able to help.