creating a form/report using information from two tables

[Nathan Vanderslice]

I think I've pretty much figured out how to link two tables by a given
field. When trying to create a form/report, how do I get the field lists
from both tables to come up?

 

[John Vinson]

I think I've pretty much figured out how to link two tables by a given
field. When trying to create a form/report, how do I get the field lists
from both tables to come up?

For a Report, simply create a Query and base the report on that Query.

This can be done on a form as well, although often the result won't be
updateable or will appear to have repeating data. Typically with a
Form you would base a Form on the "one" side table of the
relationship, and a Subform on the "many".