How to Filter Report

[mikel]

I'm very new to Access so please bare with me.



I have 2 tables, one for Gages and one for Calibrations. Gage is on the 1 side and Calibrations is on the many side. One gage will have many calibrations.

I'd like to have a report that will show the gage information from the Gage table on the top section of the form and then list all of the Calibration data from the Calibration table on the bottom of the form.

What's the best way to do this. I tried 1 Query with Gage S/N as the criteria and that works but it returns more than one. It basically has a record for each calibration with the gage data being reused for every row. But is the 1 Query the best method and I'm just doing something wrong?

I also tried 2 Queries but I don't like the fact that it asks you twice for the gage serial number.

Any help is appreciated.

Mike

[dcrake]

By the sound of it you need a main form sub form setup create you main form and show the guage details in the form header section. Then add a subform based on the calibrations table. You will be asked to provide the two fields that link the two. This should be the Primary key in the main form and the foreign key in the sub form.

David

[mikel]

You mention form/subform setup but would you do this on a report right? I have a form that I use to add information into the system and I'd like to add a button on my form that says "print report" which would open this report with the data filled out for whatever record was being viewed. Is that possible?