OK guys, I've answered a bunch of questions and this one is just for education, but it's worth asking.
Normally, my tables have a primary key, and usually it's an auto-incrementing integer - unless, occasionally, it's an alpha string like a UserName or something.
then, I may have a "dependent" table with a foreign key field which references the primary key of the "parent" table.
Now, I know it's possible to have a primary key made up of multiple columns - I call that a compound primary key myself. I do that occasionally.
However, is it possible to have a "compound foreign key" ?? I.e. a foreign key of two columns, which refers to the two columns for the primary key?
I realize you can do that by just creating the tables that way, of course, but can you set referential integrity on that? And how would you do that?
MT,
Samuel
