No Unique Index

  • Thread starter Thread starter javajoe128
  • Start date Start date
J

javajoe128

Question for the group:

I have two tables with 2 different (compound) primary keys. Am I
unable to create a cascading relationship between these tables? If so,
is there a way around this? I am attempting to do as described.

Thanks
 
Thank you for that.

Do I have to have a 1 to many relationship or can I work with a
one-one?
 
Well, that sounds a bit unusual, but yes, it is certainly possible. In that
situation the two primary key fields in Table1 would be linked to the two
primary key fields in Table2.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No Unique Index... 2
No Unique Index Found 3
relational integrity is grayed out on 1-to-1 relationship 3
Cascading relationships 4
Too Many Indexes: 16? 5
Table relationships 1
Cascade Delete Relationship Question 2
No unique index found 3

Back
Top