Incorrect circular references?
Posted: 2016-05-29 22:11
Hi,
I have 2 tables.
Table A. Address
id
name
FKcustomer
Table B Customer
id
name
defaultAddress (tbableA id)
Only way to set Address as child of Customer is to lookup FKcustomer to Customer, but then, I can set lookup on default address because circular reference.
Some idea?
I have 2 tables.
Table A. Address
id
name
FKcustomer
Table B Customer
id
name
defaultAddress (tbableA id)
Only way to set Address as child of Customer is to lookup FKcustomer to Customer, but then, I can set lookup on default address because circular reference.
Some idea?