Form with Multiple Tables

[wlee-rgpa]

I am trying to create a Client/Property Database for my firm. Basically, I
have several tables with information such as Client, Property, Condo
Association, Lender, etc. I want a form that allows me to either lookup
information from multiple tables (autofill, if available) or allow me to
enter new information. Basically, I want a form that has fields from
multiple tables that are related.
I have started some test records, 4 random records; I am starting to create
my form in my primary table, the form allows me to create new records, but
each time I insert a field from another table, the form either does not let
me create new records, or it reverts to a blank record 1 of 1. How can I
create one form (parent)that has multiple related tables, in which the
records in the related tables (child) may still need to be entered?

 

[Douglas J. Steele]

The best approach is to use a parent form based on the parent table, with
subforms based on the dependent tables.