Multiple tables in one report

[bremensleash]

Hello everyone

Anyone know how to create a report from multiple tables.

I tried making it but everytime i will choose a table and my other data table there's always a message asking for a relationship.


Hello anyone pls

can you enlighten me with this one

 

[suepowell]

HI,

The easiest way to do this is probably to create a query and base the report on that.

Create a new query and add the tables you want to use. You will then need to link the tables on the relevant fields. Drag the fields you need on the report to the grid at the bottom and save the query.

Start your new report and use the query you have just created as the recordsource, rather than the tables.

Hope this helps.

Sue

 

[bremensleash]

Thank you for your fast reply sue.

I already did what you told me, the thing is unless the other table values are relevant the report will not appear,

what i mean is to they have to be the same relevant value under the primary key.

for example
tbl_df tbl_re
rec_no: 1 rec_no: 1 and rec_no:2

Unless tbl_df has also rec_no: 2 the joined tables will not appear on the
report.

How can i display both tables having 2 or multiple records in 1 report

this is confusing.

 

[suepowell]

HI,

Still not quite sure what you are trying to do so I'll suggest a couple of possible answers.

If you mean that you have 1 master table, and that you only have entries in the other tables for some of the rows then what you do to show all the entries in the master table and those corresponding entries in the others is to set the join properties in the query.

Where you have a link in the queryright click on it and select properties, then select the option where it says show all entries in the master table, and only those in the other table where the joined value is equal.

This means you get all the rows from the master tabel, rather than only those with a matching row in the other table.

If this is not what you are trying to do then a way of producing a report where the information from the tables is not related is to produce one empty report, then to produce a subreport for each of the tables you want shown. If you dont put anything in the linking fields you can end up with some fairly odd results so it may be that you need a field in each table which just allows you to link master report with subreports.

If I have again completely misunderstood do feel free to ask again, or to attach a sample database explaining what you want and I'll try again.

Sue