form design

[Bruce Roberson]

I'm in form design within a database that has three tables defined.
Originally I selected only one of the tables to create the form for. Later,
if I go back in design mode and try to add fields from one of the other
tables, it doesn't give me that option if I click on view, field list.

Is there a way to say ok, now I want to change this form and work with
fields from all three tables?

 

[Rick Brandt]

I'm in form design within a database that has three tables defined.
Originally I selected only one of the tables to create the form for. Later,
if I go back in design mode and try to add fields from one of the other
tables, it doesn't give me that option if I click on view, field list.

Is there a way to say ok, now I want to change this form and work with
fields from all three tables?

A form can only be bound to one RecordSource. That RecordSource can be a query
that joins more than one table, but multi-table queries have to be configured
just right if you want then to be editable. There is a Help topic that
discusses when a query is updateable that you should check out.