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

Creating data relationships

P: 1
Hi All,

Can anyone help with this problem: I have designed the tables, created the relationships etc, since this morning, when when I go to view the relationships there is nothing there. When I add the tables to the relationship five of the same table appear. For example TblCustomer1, TblCustomer2 >>>>>>>> TblCustomer5. When I delete them, bar the first table, I save everything. When I go out of the view relationship and go back in the same problem happens. Any Suggestions
Oct 15 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
You seem to have relationships you're not aware of. Go into the relationships window and right click to show all tables. This will show you all the relationships. You can create many instances of the table by having a foreign key in the table that relates to the primary key of the same table. When you see the relationships in the relationship window. Go to the tables and in design view see if you have imposed this relationship unintentionally.



Hi All,

Can anyone help with this problem: I have designed the tables, created the relationships etc, since this morning, when when I go to view the relationships there is nothing there. When I add the tables to the relationship five of the same table appear. For example TblCustomer1, TblCustomer2 >>>>>>>> TblCustomer5. When I delete them, bar the first table, I save everything. When I go out of the view relationship and go back in the same problem happens. Any Suggestions
Oct 15 '06 #2

Post your reply

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