Re: How can I set relationship with two table comuns that are different names
Antony,
the actual names of the columns don't matter for FK creation. Open your Address table in the model and switch to the "Foreign Keys" page. Click in the left list on the empty line to create a new FK. Select the referenced (target) table there (which would be Persion in your case). Make sure your FK is selected once this is done.
Then on the right hand side you have a list of colums from your Address table along with checkboxes. Check the one in front of personid and select the target column in that entry (via that drop down control). If needed adjust other parameters.
That's it.
Mike
Mike Lischke, MySQL Developer Tools
Oracle Corporation
MySQL Workbench on Github:
https://github.com/mysql/mysql-workbench
On Twitter:
https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to
http://bugs.mysql.com
MySQL documentation can be found here:
http://dev.mysql.com/doc/refman/8.0/en/
Subject
Views
Written By
Posted
964
July 17, 2013 03:22PM
Re: How can I set relationship with two table comuns that are different names
485
August 09, 2013 02:24AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.