rcisco,
I know this is an old thread now and I hope you have things worked out by now; however, if you're still struggling with this issue I'd be happy to lend a hand.
If I understand correctly, what we have:
[tblWorkPlan]
[tblWorkPlan].[ID] PK
[tblWorkPlanSteps]
[tblWorkPlanSteps].[ID] PK
[tblWorkPlanSteps].[WorkOrderNumber] FK to [tblWorkPlan]
main form is for [tblWorkPlan] === parent
subform is for [tblWorkPlanSteps] === child
I want to copy both the record in the [tblWorkplan] table and the related records in the [tblWorkPlanSteps] table
and append them to the same respective tables.
Ok, this really makes very little sense to copy the same information between the two tables.
Sounds as if your database either needs to have another table or there may be some normalization issues to address:
home > topics > microsoft access / vba > insights > database normalization and table structures
On paper, what I am suspecting is that you have something like:
Work Plan 123456
Step A
Step B
Step C
Work Plan 7890123
Step A
Step D
Step E
etc... and you're needing a way to track these different work plans.
Is that correct, if so, then you need another table that has a many:many relationship between your current tables.