I have two tables Table1(FileID,BundledFileID,Domain)
and Table2(FileID,FileType,FileName)
.
In Table2 FileID
and FileType
are the composite primary key. I want to create a foreign key relationship from Table1.FileID to Table2. Is it possible to do this? Then how plz help.
I am using SQL Server 2005