How can I set relationship with two table comuns that are different names

[Antony Paul]

Hi,

I have a problem with ERR Diagram. I have opened my existing database in MySQl Workbench for creating ERR Diagram. I have a problem with setting relationship with tables. I have used different names in different tables. So now in ERR I can't set relationship with these fields.

For eg:

Table 'Person' fields [pid, name, age, sex] 'pid' is primary field
Table 'Address' fields [id, personid, address1,address2,street,city]

In Address table, 'personid' is used to connect with person table.

How can I set realtionship with these fields?

Thanks,
Antony.