Data from multiple tables into one form

[Guest]

I'd like to bring data from multiple tables inot one form. i am using tabs on
a form and would like info from one table to be placed in one of the tabs of
the form and info from a different table inot the same or different tab of
the form. when i pull down the field list i only see the fields for the
"native" table. is there a simple way to do what i want to do?

john

 

[tina]

you can base your form on a multiple-table query. note that multiple-table
queries are sometimes *not* updateable, which will be an issue if you need
to add/edit/delete records in the form.

alternately, you can use subforms to display data from additional tables, in
a single main form. tab controls are particularly handy for organizing
multiple subforms on one main form; just place one or more subforms on each
tab.

hth