Multiple Foreign Keys

[AEtherson]

I'm a newbie to SQL Server. I'm trying to create a database where multiple fields in a table can point to one field in a second table. I create a foreign key from Field1 in Table1 to Field1 in Table2. I then try to create a Foreign Key from Field2 in Table1 to Field1 in Table2. It won't let me do this as the Foreign Key has the same name. Any ideas?

Table 1 Table 2
Field1 Field1
Field2 Field2
Field3 Field3
Field4 Field4
Field5 Field5
Field6 Field6
Field7 Field7
Field8 Field8
Field9 Field9

 

[fredericofonseca]

give the foreign key a different name. thats what it is complaining about if I understood correctly your problem.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886