Forms and multiple tables or queries

J

JMill248

I am pretty new to Access 2003 and I was wondering is there any way
that I can create a form that uses multiple tables? If so how do you
do it?
 
D

Douglas J. Steele

An updatable form, or a read-only form?

You can create a query that joins the multiple tables together. Odds are,
though, that the query won't be updatable.

If you need to be able to update, you almost always will have to use a form
with subforms (each "other" table being on one subform)
 
A

Allen Browne

JMill248 said:
I am pretty new to Access 2003 and I was wondering is there any way
that I can create a form that uses multiple tables? If so how do you
do it?
Click to expand...

Create a query first. Then create a form based on the query.

If you are new to Access, this may not work very well. Some multi-tables
queries will be read-only (i.e. you can't edit anything.) You also need to
be really clear about which table you expect a new record to be added to
when you type one into your form: in general, it's not going to add to
multiple tables at once.

Depending on what you are doing, it might be better to use a form (bound to
one table), and a subform (bound to the related table.)
 
Top