cloudsBro
April 29th, 2007, 11:48
I am trying ot write SQL that will allow me to reference the same field to two tables. By that i mean I want one Primary Key to reference a Suspect table and a Contact table. Both tables have a foreign key of Case_Number. So far I have this:
create table Cases
(
Case_Number integer not null primary key REFERENCES [Contacts(Case_Number) Suspects(Case_Number)],
Im not sure if this is the right way to do it and would appreciate a pointer on how to do it. By the way I am using MicroSoft Access 2003.
create table Cases
(
Case_Number integer not null primary key REFERENCES [Contacts(Case_Number) Suspects(Case_Number)],
Im not sure if this is the right way to do it and would appreciate a pointer on how to do it. By the way I am using MicroSoft Access 2003.