Problem in creating one to many relationship among three tables

[Mustafa Sherazi]

Hello,

i have three tables in my database. i m trying to create one to many relationship among those three tables. relationship created between two tables, but when i try to create relationship with third table it always offer indeterminate. Please reply me as soon as possible. Thanks

[zmbd]

Well, without your table design there's no way to help.

So, something like:

tbl_people
tbl_address
tbl_states
tbl_telephone
tbl_directory
tbl_book

tbl_states 1:M with tbl_address

tbl_book: M:M with tbl_people
tbl_book: M:M with tbl_address

etc...