Subject Foreign Key on 2 or more columns
Author svanderclock
hello,

in tableA i have some record with the field ID_contact that point to the table ContactA or to the table ContactB. so in this way i can not create a foreign key on my field ID_Contact.

How to do ? i thing by stored procedure, but what is the best way and the most efficient way to do that in store procedure ?

thanks you by advance

--
stephane

http://www.arkadia.com/usa/real-estate/for-sale/france/ile-de-france/paris/listings/
http://www.arkadia.com/fra/immobilier/vente/france/ile-de-france/paris/annonces/
http://www.arkadia.com/rus/real-estate/for-sale/france/ile-de-france/paris/listings/