By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,368 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Problem in creating one to many relationship among three tables

P: 1
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
Feb 8 '14 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
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...
Feb 8 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.