Inconsistent Data

M

Mike

I have a database with 3 major tables:

Protocol_IndexTbl
Couple_IndexTbl
Chancery_IndexTbl

All three tables share a relationship. The primary key in Chancery_IndexTbl
is related to a foreign key in the Protocol_IndexTbl and the
Protocol_IndexTbl primary key is related to a foreign key in the
Couple_IndexTbl. The foreign key in the Couple_IndexTbl is only there to
link the two table together. When working with forms the data that comes
from the Protocol_IndexTbl doesnt update the fields in the Couple_IndexTbl.
If I manually change the foreign key in Couple_IndexTbl in datasheet view the
data then cascades over. But is there a way that when I go from the
Protocol_IndexTbl from the form to the Couple_IndexTbl form that the foreign
key in Couple_IndexTbl is already equal to whatever the primary key in the
Protocol_IndexTbl?
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Update data from previous form? 6
Append Crosstab Query to Existing Table 0
Need Suggestions to Eliminate Unplanned Table Behavior 4
VBA word change keys 0
Auto populate value from one task to another in MS PROJECT 0
No Unique Index... 2
Create Foreign Keys 1

Top