Using Three tables in a form

[Jessica]

How can i use three different tables in a form. They are realted except each
one of them them have different information pertaining to the main table.

 

[Sean Timmons]

Create the form in Design View.

Click on the box at the very top left of your form.

In the record Source box, click on the ...

Add your tables like you would in a query. (Right Click, Add Table)

 

[Larry Linson]

How can i use three different tables in a form. They are realted except
each
one of them them have different information pertaining to the main table.

Create a Query, joining the Tables on the common Field. Use the Query as the
Record Source of the Form -- but, you may find the Query is Not Updateable
(and, thus also the Form). However, if the form is only for viewing, not
updating, this may be fine.

If you need to update, you may be able to do so by including the Primary Key
of each Table in the query. If that doesn't accomplish your goal, then you
are likely to have to imbed a Form for each of the two related Tables in two
Subform Controls on the main Form.

Larry Linson
Microsoft Office Access MVP