Need Query Help

[wirelad]

Hello,

I have 4 forms - 4 tables that stores data from each form.

I want to create a report that shows 4 or 5 fields from each form

EG.

Form1 = Products
text1= date
text2= time
text3= name

Form2 = Prices
text1=date
text2=time
text3=name

So On....4 x's different form titles

All the forms store the same data - they just cover different products.

I want the report to show me a list of all the data fields needed.

What's the best way to complete this task?


Thanks

Mike

 

[JP]

Your question is confusing.

First, and most importantly, what do you mean that you want to create a
report that shows 4 or 5 fields from each form. Reports are based on
tables, not on forms. Do you mean that you want to show 4 or 5 fields from
each table???

Secondly, what do you mean that "all the forms store the same data - they
just cover different products". That sounds like a terrible database
design, and certainly not normalized. One would expect that each form would
be showing a set of info for all products (e.g., one form shows the basic
info for all products, another shows the prices for all products, etc.).
Please explain.

Assuming that you want 4 or 5 fields from each table, there are two ways to
do it:

1. If each table has a 1:1 relationship to the other tables, then you
should be able to create a join query that pulls together all the fields
into one recordset and you can then use that recordset as the input to the
report.

2. If there are 1:Many relationships, then each of the Many's would be a
subreport on the report.

Under either circumstance, there should be a key field that links together
each of the tables. For example, you might have a product ID field in each
table.

If you really meant that you have different tables for different products,
then you're probably in a lot of trouble.

 

[wirelad]

Gulp! Erm....Sorry - Im kinda new to this.

Yeah I did mean pulling a report from a table.
Any yeah, your probably right again. It is a terrible database.

The thing is, I started out with 1 form and 1 table. Since then, 5 more
products came along. I found it easier to just copy the 1st and rename has
the 2nd, 3rd and so on.

The data that is typed into textboxes, although is the same on most of the
forms,
there are some differences. However, I have 5 forms with 5 tables.

What I need to do is create a report that pulls 4 sets of data from each
TABLE
onto the report.
Anyhow, from you comments below. I'm going away to look at this sub-report
within a report

Thanks JP

WiReLaD