Re: foreign key references two different table?

On 30 May 2003 15:13:48 -0700, susana73_at_hotmail.com (Susan Lam) wrote:

>I have 3 tables.
>
>parent1 (id, ...)
>parent2 (id, ...)
>child (id, memberid, type)
>
>child.memberid came from parent1.id and parent2.id. child.type
>distinguishs where the memberid are from parent1 or parent2 table.
>
>I would like to have a fk relationship between child.memberid ->
>parent1.id and parent2.id. However, I can't create two separate fks
>because parent1.id and parent2.id together are not unique.
>
>Is there a way to create one fk to two different tables?
>
>Thanks.
>Susan

Hi Susan,

Not by means of foreign key constraints.....you can either

1. Let a trigger do the job for you.
2. Review your data model to find a more "clean" relational solution, if at all possible....
   • Kenneth Koenraadt