I have the following tables in my Access database.
A < B < C < D
(The "<" represents a one to many relationship.)
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 keys.
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 table B.
All data in child tables must be included in the copy process.
In other words, for a given row in table A, by use of buttons in the forms for each of the stages 1 – 3, the user shall be able to do the following:
all data for stage 1 are copied to stage 2 (for user modification), then
all data for stage 2 are copied to stage 3 (for user modification), then
all data for stage 3 are copied to stage 4
Is it possible to do this in Access 2010?
If yes, how?
Queries?
Triggers?
Vba?
Macros?
A < B < C < D
(The "<" represents a one to many relationship.)
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 keys.
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 table B.
All data in child tables must be included in the copy process.
In other words, for a given row in table A, by use of buttons in the forms for each of the stages 1 – 3, the user shall be able to do the following:
all data for stage 1 are copied to stage 2 (for user modification), then
all data for stage 2 are copied to stage 3 (for user modification), then
all data for stage 3 are copied to stage 4
Is it possible to do this in Access 2010?
If yes, how?
Queries?
Triggers?
Vba?
Macros?