Report Structure

  • Thread starter Thread starter Mike D.
  • Start date Start date
M

Mike D.

Hi.

I have two tables. "RMA" is the main table with "ID" as
the primary key. "Repair Parts" is the 2nd table. The
relationship between the two is ID is unique with a one-
to-many relalationship with "RepairID" in "Repair Parts."

I would like to create a report that, when opened, would
prompt the user to enter the RMA Number and would create
a one page report with all of the repair parts for that
record.

How do I strucutre the report to prompt the user?

Thanks,
Mike.
 
Absolutely simplest way for the programmer is to use a parameter query. But
that does require your user to enter the RMA number exactly.

Field: ID
Table: RMA
Criteria: [Enter RMA Number]

That assumes that the ID field is the RMA number.

A more complex way is to build a form with three controls on it. A combobox to
hold the RMA Numbers for the user to select, a button to open the report, and a
button to close the form.

In the underlying query for the report, you would have
Field: ID
Table: RMA
Criteria: Forms![YourFormName]![comboboxName]

When you click the button (use the wizard to build the button for opening a
report), this should automatically open your report with the correct data.
 
Back
Top