Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Realtionships between tables

Status
Not open for further replies.

madvalpreston

Technical User
Apr 7, 2011
142
GB
Hi

I created tables in MYsql (I am fairly new to Mysql) and used the workbench.

I find I have a couple of problems which i hope some of you can advise me on.

1. I created all the relationsips using the EER in the workbench. This is ok (I think), but when I have added a new table in (not using the EER model, but directly into the DB) it does not show on the table within the EER model. How can I get my new tables to show up for me so i can add them into the EER OR do i have to always add new tables within the EER model
2. because I cannot add the tables, how can i set up the relationships between the new and exisiting tables and also see that they are related ok.

I have all the tables linked into Access and I suppose I could line within Access but probably not the best way to go.

Thanks for any advice in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top