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.