Subform Reports

[srideout2525]

I have a form with a subform.

I want to have a report based on each individual record in the subform.

the subform, which is based on a table where the primary key is a combination of two primry keys in it's related tables.

so i have an order which can have multiple rates, and rate which can belong to multiple orders, so the intersect table has OrderID and RateID as it's primary key.

SO..how can I open the report based on the orderID and RateID?

I have reports which open based on the OrderID. But now want to have to pieces of criteria to open another report.


Any help...great!! Further explaination, I'd be glad to give, to get the help!!!

Thanks

 

[saintsman]

You need a sub report in your report exactly the same way as you have done your form.