creating a form/report using information from two tables

  • Thread starter Thread starter Nathan Vanderslice
  • Start date Start date
N

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?
 
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?
Click to expand...

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".
 
Back
Top