Help With a report

I have 3 tables RMA, Company and Product which have a replationship to join them.
Company.ID = RMA.Company
Product.ID = RMA.Product
I have a form which populates the RMA table, on which the Company Name
is a lookup from the company table and Product is a lookup from the
product table.
From the information inputted into the form I need to create a report
that displays fields from the RMA table and the Address field from the
company table.

Problem, the report is a delivery note so is there a way to
show the Address from the company table by default but also be able to
over type it if it needs to be different.

I thought I could do this by adding a delivery field to the RMA table and entering the address in the RMA form if different then use a query, but the select query returns all records with no changes and the update query makes the Delivery fields blank.

Hopes this makes sense

I had kinda of the same problem. I made a report and charts from an inspection department. There are different types of inspections. When I printed my report I wanted the choice od which department to print in the report automaticly.

I wanted to do this from a form so anyone could look at whatever dapartment they wanted to.

to start I made a table that listed just the inspection departments that is separate from the inspection log.

in the query I added this info:

Feild: Inspection Type
Table: PPR DATABASE
Total: Group By
Critera: [Forms]![charts]![Inspection Type]

So now when I use the pull down menu on my form and select whichever department. it puts in into the report.

Now on the report I added a text box and formatted it as Inspection type like this:

=[Forms]![charts]![Inspection Type]

So when I pull up the report it put the info in the text box from the pull down menu on the form.


I don't know if this will help.