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]