I'm trying to build a "multilayered" form and I'm not having any luck.
Basically I have 3 tables: Test ID, Data Item, and Revision.
Each test event has a unique Test ID. For each test event there are multiple sets of data that are delivered which have their own unique id. And for each Data Item there may be multiple revisions delivered.
The way I have the form set up is there is the main form for the test event. Embedded is a Data Item Subform where you can scroll through each Data Item delivered for that test event. Inside that subform is another subform where you can scroll through each revision delivered for that Data Item. The problem is that, although the Data Item numbers and revision numbers never change, occasionally the test event ID may change based on program redirection. With the relationships that I have set up, when I update the Test ID it gets updated in the Data Item subform/table, but it doesn't update the Revision subform/table.
How do I set up a relationship where if I make a change it gets updated thoughout?