Hello
I need to link two tables,
one has a primary key (Membership) and one doesn't (results),
results doesn't have any primary key values, I have added a membership number column can I bind the results table column membership number to the values in the membership table?
If so how?
C
You need a FOREIGN KEY constraint between the 2 tables. Just set a FOREIGN KEY constraint on the membership number column of 'results' talbe which references the Primary Key column of Membership table. You can use such T-SQL statement:
ALTER TABLE Membership ADD CONSTRAINT
FK_MemShip_Num FOREIGN KEY
(
[membership number]
) REFERENCES dbo.titlex
(
[membership number]
)
For more information, please refers to following article:
http://msdn.microsoft.com/library/en-us/createdb/cm_8_des_04_8ypg.asp?frame=true
