myLittleTools Community Forum

Welcome Guest Search | Active Topics | Members | Log In | Register

Relationships Options · View
Posted: Saturday, February 13, 2010 2:10:33 AM
Rank: Newbie
Groups: Member

Joined: 2/13/2010
Posts: 1
Points: 3
Location: USA
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!

Posted: Friday, February 19, 2010 4:24:12 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
Looks like your MSAccess to SQL Server has not been properly done.
Users browsing this topic

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

Theme created by myLittleTools
Powered by Yet Another version (NET v2.0) - 3/29/2008
Copyright © 2003-2008 Yet Another All rights reserved.