Need Query Help

W

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
 
J

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