How to add mailing addresses to an invoice report

[wirejp]

I have to prepare invoice statements to send to my clients. From my invoices query, I was able to generate the invoices as a report.

However, I want to add two types of mailing addresses to this invoice report: "From" mailing address (my company's mailing address) and a "To" mailing address (the recipient's mailing address).

I have created a Clients table which contains the company's mailing address details. There is a separate ClientContacts table which contains the primary contact name and the secondary contact name (along with their email addresses) for the respective company. On the ClientContacts table, the ClientID is the foreign key which is linked to the Clients table. On the Invoice table, the ClientID is the foreign key which is linked to the Clients table.

My problem is how to incorporate this information on the invoice report.

Previously, but I added the clients and client contacts fields to the query and I noticed that the invoice data had doubled. As an example, the primary contact person was linked to an invoice A on one line item, and then the secondary contact person was linked to same invoice A data on the next line. Is this what is expected to happen?

I wanted the mailing addresses to appear in the page header of the report and the invoice data to appear in the detail section of the report.

What I have done is to create an unbounded text box on the invoice report and manually type in this information. Is there a way to add my company mailing address as a "From" mailing address and the recipient's mailing address as a "To" mailing address on the report automatically?

[twinnyfo]

Previously, but I added the clients and client contacts fields to the query and I noticed that the invoice data had doubled. As an example, the primary contact person was linked to an invoice A on one line item, and then the secondary contact person was linked to same invoice A data on the next line. Is this what is expected to happen?

This will happen in your queries when you have two contacts associated with that Client.

If you want just the address, add just the address information from the Client Table. If you must use the contacts, then have a separate query that lists only the contacts, and add this information in a Subreport on your main report. Use the Client ID to link the Sub report to the main report in Master Child relationship.

For your mailing address, you can perform similar actions.