Cascading Combo Boxes

[StacyStacy]

I have submitted a thread on last month but had to stop working on this project due to another project that took precedence. I am now resuming the completion of this project. Could I get some help with the following error:

Cannot perform cascading operation. It would result in a duplicate key in table".

Is there a problem on the table level?? Would you check out my relationships? Thanks.

Here's the link for this thread:
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=49959

 

[dcx693]

While your other thread did have to do with cascading combo boxes, the error message you posted is not related. It has to do with you table relationships, as you suspected.

I cannot comment further on the problem without knowing more about the structure of your database. You might be trying to update the value of a primary key in a table that has a relationship with another table with which you've enabled "Cascade Update Related Fields". What exactly are you doing when you get the error?

 

[StacyStacy]

The error message is directly related to combo boxes. In order for the combo boxes to work properly, in the manner that it was sent to me, the tables had to be related as it is. But, it's creating the error when I try to advance to the next record. I will resend the sample that was sent to me. Please try to advance to the next record and you will see the error message.

Thanks.

 

[dcx693]

What exactly do you choose from the combo boxes that produces the error?

 

[StacyStacy]

Basically anything. Choose 506 for Hinds Community College and select any location in the second combo box. Then, advance to the next record (#2)

 

[dcx693]

Tried that. The error I am geting is:

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remote the index, or redefine the index to permit duplicate entries and try again."


This is very different from the error you posted. Is there something else I should try?

 

[StacyStacy]

No. I had changed something in the table relationship. Can you work with what you have. I am unsure as to how I should fix this. I sent you a private message as well.