I have several tables that I want to create relationships for. Each table contains a field named Cv_Index. I can create a primary key for the basic_data table, and can create 1 foreign key in the advance1_data table...

My problem is, I have 6 more advance_data tables (2, 3, 4, 5 & 6)... and cannot create a foreign key for those using the same Cv_Index feild. I get an error stating it creates a conflict.

How would I relate these using the unique Cv_Index feild?

I am new to MSSql, but, have done this in access. My database was converted from access to MSSql. This relationship worked quite well in access, and I'm hoping I don't have to manually update 5000 records in each table!

Thanks!