Forms based on multiple tables / queries

[meghanwh]

I have a table Prospect Tbl that draws input from 3 other tables (using
the Look Up function in the table's design view). Then, I have a query
Prospect Qry that puts this table together with another table New
People that also draws off a few different tables. I want to create a
form that is based on Prospect Qry, but it won't let me update any of
the records. I know you can't have too many layers and still be allowed
to update records, so is there another way to do this? Thanks.

 

[Rick Brandt]

I have a table Prospect Tbl that draws input from 3 other tables
(using the Look Up function in the table's design view). Then, I have
a query Prospect Qry that puts this table together with another table
New People that also draws off a few different tables. I want to
create a form that is based on Prospect Qry, but it won't let me
update any of the records. I know you can't have too many layers and
still be allowed to update records, so is there another way to do
this? Thanks.

Subforms.