And... You can also have a column that has both a primary and and a foreign key defined for it. For example, a membership association might have a table of Members with a primary key defined on MemberID. Some members are also on the Board of Directors. There could be a separate Directors table that also has a MemberID column, which is a primary key in the Directors table, and also a Foreign Key referencing Members.MemberID.
MemberID is unique within Directors, but also has to be a valid member from the Members table. Bill On Wed, Apr 30, 2008 at 6:17 PM, Rachael Malberg < [EMAIL PROTECTED]> wrote: > Oh sure and did you know you can have Primary and mulitple Foreign Keys > with in the same table? >
