I have 4 tables that cascade through 1-to-many relationships. I would like to build a form, not in datasheet view, that cascades through the different sub-forms and updates all the related tables.
So far I've wanted to use tabs on a form for each sub-form, but only the top level table and the immediate next table get updated due to the Master/child field update for sub-forms. the next two sub-forms (Level 3 and Level 4) do not get updated. I have a feeling that it has to do with the relationships and how they are linked, but I do not have the knowledge or experience to figure this out.
tbl-Level_1 -> tbl-Level_2 (1 to many)
tbl-Level_2 -> tbl-Level_3 (1 to many)
tbl-Level_3 -> tbl-Level_4 (1 to many)
I have used ID in the Master linked (1-to-many) to a field in the child for my relationships.
If I have to use code, no problem, please send me in the right direction to learn this aspect (I have steered away from custom code).
Any help, insight, recommendations, comments would be greatly appreciated.
Justin
So far I've wanted to use tabs on a form for each sub-form, but only the top level table and the immediate next table get updated due to the Master/child field update for sub-forms. the next two sub-forms (Level 3 and Level 4) do not get updated. I have a feeling that it has to do with the relationships and how they are linked, but I do not have the knowledge or experience to figure this out.
tbl-Level_1 -> tbl-Level_2 (1 to many)
tbl-Level_2 -> tbl-Level_3 (1 to many)
tbl-Level_3 -> tbl-Level_4 (1 to many)
I have used ID in the Master linked (1-to-many) to a field in the child for my relationships.
If I have to use code, no problem, please send me in the right direction to learn this aspect (I have steered away from custom code).
Any help, insight, recommendations, comments would be greatly appreciated.
Justin
