Form from two tables

[galsaba]

Is it possible to create a form that will get and update the data from
two tables?
do some of the fields will be from one table, and other from a
different table?

thanks,

galsaba

 

[John Vinson]

Is it possible to create a form that will get and update the data from
two tables?
do some of the fields will be from one table, and other from a
different table?

Yes.

Usually the simplest way to do this is to use a Form based on the
"one" side table in the relationship, and a Subform based on the
"many".

It's also possible to base a Form on a Query joining two tables - *if*
the query is updateable. To be updateable you must have a unique Index
defined on the joining field in the "one" side table, and include the
joining fields from both tables in the query; you'll see multiple
repeats of the "one" side data, which can be confusing to users.


John W. Vinson[MVP]