I am having real trouble trying to create a basic report in the form of an invoice and its driving me up the wall!!
I need to collect data from 4 different tables.
tblcompdata - For the page header and footer
tblclint - for the address (also in page header)
tblmain - for the invoice number and date sent
and
tblwork - for the job details
The problem I am having in trying to organise the report so each invoice is printed on a seperate page.
Currently I can get the footer etc to print on each page but the job details are in the "detail" section and so no matter how i group the report they come out on the same page. So invoice 1 has all the job details for all the invoices!
I am not sure but the problem seems to be something to do with the groupings or the fact that I need data from 4 different tables.
Any help would be most appriciated!
Stacy
I need to collect data from 4 different tables.
tblcompdata - For the page header and footer
tblclint - for the address (also in page header)
tblmain - for the invoice number and date sent
and
tblwork - for the job details
The problem I am having in trying to organise the report so each invoice is printed on a seperate page.
Currently I can get the footer etc to print on each page but the job details are in the "detail" section and so no matter how i group the report they come out on the same page. So invoice 1 has all the job details for all the invoices!
I am not sure but the problem seems to be something to do with the groupings or the fact that I need data from 4 different tables.
Any help would be most appriciated!
Stacy
