Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Rename the field ParentID in the Governate to just Governate.
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.
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
I see ...
OK i will try
Thanks..
Hi, if that answered your question, please mark as correct/helpul to close the trend and help other in the future.
Cheers,
Andrés