K
Ken Snell [MVP]
The best way to do this in ACCESS is to use a form/subform setup for
entering data. The main form is used to enter the parent table's data, and
the subform is used to enter the child table's data. You link the main form
and subform by the primary/foreign keys, and ACCESS automatically enters the
values into the foreign key fields for you.
Take a look at forms/subforms in Help. Also, I recommend that you obtain a
good ACCESS book that will discuss these and other helpful topics; see
www.viescas.com for some good book recommendations, or visit your local
bookstore or online store (www.Amaxon.com or others).
entering data. The main form is used to enter the parent table's data, and
the subform is used to enter the child table's data. You link the main form
and subform by the primary/foreign keys, and ACCESS automatically enters the
values into the foreign key fields for you.
Take a look at forms/subforms in Help. Also, I recommend that you obtain a
good ACCESS book that will discuss these and other helpful topics; see
www.viescas.com for some good book recommendations, or visit your local
bookstore or online store (www.Amaxon.com or others).