Good day all!!! I have the tables, as in image above, and I'm trying to create the relationships. I got stuck at creating a relationship between tables 'member_provider' and 'dependant_provider'.
As you can see, member_provider has a composite primary key that is made up of to foreign keys 'Member_RowID' and 'Provider_RowID'. I want to maintain this composite primary key and then create a relationship with dependant_provider using Member_Provider_RowID. I have tried adding Member_Provider_RowID to the composite key in member_provider but when I try to create the relationship I get the following error:
"The columns in table 'member_provider' do not match an existing primary key or UNIQUE constraint"
How would I go about maintaining the the uniqueness of the tables two columns.
I'm using MSSql Server 2008...
Thanx in advance.