Form-new record in 2 tables

  • Thread starter Thread starter Tina
  • Start date Start date
T

Tina

Beginner here...can't seem to find out how to set up a
form where I can enter a new record into more than 1 table
that has a relationship with another. Such as: tblClient
will always have a new tblRegion; client may have many
regions therefore one-to-many(client-to-region)
relationship. The region must have an existing client
before I can enter a new region. How can I enter new
information for both of them on one form?
Thanks
 
Tina,

What you need to do is to create a 'subform' that you can
embed on your Client form. If you set your Master/Child
relationship to be the primary and foreign keys it will
allow you to enter multiple Regions with no problem. See
'subform' in Help and/or look at the sample Northwinds
database to see how this is implemented. It is one of the
major 'key features' of Access.

Gary Miller
Sisters, OR
 
Back
Top