Report to include multiple tables.

L

Lisheen

Hi All

Back again with another little issue, well may be not so little!
have a Main Form with two sub forms on it each based on differen
table, I then have a select query triggered by a command button whic
opens a report based on this query. The purpose of this is to create
report based on the form including the subforms, this seems to work fin
when I have entered information on both subforms and the main form bu
if I do not need to enter information on any one of the subforms th
entire report is blank. Any ideas would be gratefully accepted.

Thanks
 
P

PC Datasheet

Change the joins to the subform tables in your report query to Type 2 or
Type 3 where it says include all the records in your main table and only the
matching recprds in the subform table.
 
L

Lisheen

Sorry for being such a numb skull, but how do I do this? I dont reall
understand
 
J

John Vinson

Hi All

Back again with another little issue, well may be not so little! I
have a Main Form with two sub forms on it each based on different
table, I then have a select query triggered by a command button which
opens a report based on this query. The purpose of this is to create a
report based on the form including the subforms, this seems to work fine
when I have entered information on both subforms and the main form but
if I do not need to enter information on any one of the subforms the
entire report is blank. Any ideas would be gratefully accepted.

Thanks.
Click to expand...


Click on the Join lines from the main table to the related tables.
View the relationship's Properties. In the Join Type box which will
appear, choose Option 2 (or maybe 3) - "Show all records in <main
table> and matching records in <child table>".

This "Outer Join" will show the main table records regardless of the
presence or absence of data in the related tables.

Note also: you're not storing data in subforms. You're storing data IN
TABLES, using a subform as a tool, a window. It's a jargon distinction
but an important one: the tables are *basic*, the forms are secondary.

John W. Vinson[MVP]
 
Top