I have the following tables in my Access database.
A < B
< C < D
(The "<" represents a one to many
A given row in table A can have up to 4 children
(stages) in table B (stages 1 to 4).
The other one to many
relationships do not have any limitations as far as the number of
children are concerned.
All tables have AutoNumber primary
When the user clicks a button in a form, I want to:
Copy all data in the current stage (current row) in table B
(corresponding to a given parent row in table A), to the next stage in
All data in chil