Help with multi-table report

E

EAB1977

Hello everyone,

I am trying to create a report that gives me the detail of each
transaction in a report. I have my tables set up like the following:

tblProducts ---> tblHistory 1:M

tblTransaction ---> tblHistory 1:M

tblHistory has a 1:M relationship with the following tables:

tblRepair
tblCalibration
tblActiveInactive
tblChangeLocation
tblScrap
tblActiveInactive

With this many tables, is it possible to get the detail report that I
want? This is a little too advanced for me and could use some help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting the hghest value in a one-to-many relationship 5
"Compile error in table level validation expression " after format 0
Calculate beginning balance, but print details on report 3
Direct & Indirect Reports 0
Report setup 2
Using Subreports to create a Main Report 1
Assign batch # to rcds so report can be recreated. 4
Charting Missing data accross three related tables by region and % 1

Top