report that contains fieds fro multiple tables

[Freddie81]

Hi Guys



Im building a database for qoute and invoice purposes and Im now at the report stage where Im trying to create a report to show the data from 4 different tables. When I use the report wizard to create it I get an error message about Type Mismatch when I try to open it in preview mode. I then tried creating it myself via a blank report. I finished the header and footer sections but now that I want to add the details section from the other tables (Invoice, invoice details, products and customer info(4 tables) It keeps asking me to specify new relationships. However when I do this al my previous records or fields used in the header become blank? Am I missing something to create a report from 5 different tables?

[June7]

Probably, but without knowing more about your data structure and relationships really can't say what. If you want to provide db for analysis, follow instructions at bottom of my post.

At least post the query SQL statement you are attempting.

As for the type mismatch, look at the data types of the fields you are attempting to join on.

[Freddie81]

Her is the relationships of my database.

The fieds ar all mixed, som shorttext,some autionumber etc. What I want to do is create a report that has :
Header:
My Compny name and details and the invoice number and invoce date

Footer:
My banking details ( labels) and ome caculated fields for totals
In the etails section I need the invoice details ( customer name,adres,contact detais etc) and the transsaction details( product code, product, qty and price)

However when I try to create this report via the wizard it makes it but wont open it saying type mismatch in expresion.

I thn tried creating a blank report and desing it myself with logo etc like I want it. When I add y compny detils in the headr it works but as soon as I tr to add the invoice nr or invoice date to the geafer too it makes all my company details blank and it want new relationships?

[June7]

Your tblCustomers links to both tblInvoices and tblCompany_Details are wrong.