The table structure works fine - I can see that you have a separate table
for each entity in the database.
That stucture is similar to an inventory database that I have developed.
In the invoice report for that database, I have one main report with 8 sub
reports.
There is a sub report with the business name, another with business contact
details and many more to deal with all the other details and calculations
needed on the invoice.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

"Dennis" wrote in message
...
Jeanette,

Thanks.

Is the database structure ok? I wasn't sure if I was having problems the
database structure or the report. When I finally wrote out my questions,
I
thought about the sub-report you suggested. But I was not sure if my
conceptualization issue is with my db structure of my vison of the
invoice.

Thanks for you advice.

Dennis.,