Fields from more than one table in reports and forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I usually use the Report and Form Wizards (not the auto ones) to create my
forms and reports. I know it is possible to pick fields from different
tables to go into reports and forms and have done this on some occasions. I
had relationships set up between the tables when I did this. Is it always
necessary for the tables to be related if I am going to use fields from more
than one in a report or form?

Just trying to get my head round Access a bit more.

Thanks for any insights.

I use the 2000 file format.
 
To include multiple tables in a report, you simply add the various tables to
the query upon which the report is based. The tables must have some common
filed in order to pull data from two tables onto one detail line of the
report. You can build this relationship in the query though, you don't have
to have it in your database's relationship window.
 
Thank you for this. I know you can use a query with multiple tables as the
basis for a report. You can also select fields from more than one table when
creating forms and reports using the wizard. My question is whether these
tables have to be related for this to work – both in a form or a report.
 
Back
Top