tables to match tabbed forms

  • Thread starter Thread starter micromoth
  • Start date Start date
M

micromoth

If I have a 5 child and a parent table which are connected with an
FK/PK relationship.
I want a tabbed form the first part for the parent and the second for
the child.
when I complete the parent part I want the autonumber transfered
prefilled into the the child table and the child form.

What process do I need to do to achieve this?

Any website links for this would be useful. out of five books none go
beyond one subform.
 
When you create a subform, Access sets up the LinkMasterFields and
LinkChildFields properties of the subform control.

If these are set correctly, the value of the field(s) names in
LinkMasterFields (typically the autonumber from the main form's table) is
automatically assigned to the matching field(s) in the subform. So, there's
nothing else you need to do.

If it is not working for you, just set these properties correctly.
 
Back
Top