Creating data relationships

[YouTube]

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

[MMcCarthy]

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