Relations between tables

[Anonymous]

Hi Guys,

I have these tables :

these two tables have one record in side each table,the value of ParentID in Governorate table is the same value of Governorate field inside Bakaries table so i want to define the relation between them and draw line between associated fields.

swuehl‌

stalwar1‌

rwunderlich‌

omarbensalem‌

[petter]

Rename the field ParentID in the Governate to just Governate.

[Anonymous]

Yes you are right Mr. Petter

but the tables in my case  are hierarchy in other word if i have another table called Hier and inside this table there is a field called Governorate but the parent

of this table is Governorate field inside Governorate table not Governorate field  inside bakaries table.

I hope i could explain clearly.

petter-s‌

[andrespa]

You need to give different names if the fields are refering to something different. That been said, you could name the Governorate field between Governorate and Bakaries tables something like key_governorate.

Hope it helps,

Andrés

[Anonymous]

I see ...

OK i will try

Thanks..

[andrespa]

Hi, if that answered your question, please mark as correct/helpul to close the trend and help other in the future.

Cheers,

Andrés