tables to match tabbed forms

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.
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

tabbed forms - tab 3 link to tab 2 1
Creating a Form To Update Multiple Tables 2
Access won't accept records entered in my sub-form 3
Linking subforms on a tabbed page 1
Display Child Records in subform 7
Linking forms based on two fields 1
subform new records 11
Parent with five children tables - single table 5

Top