Dennis, as Jeannette says, you can do what you need with this structure.

In another group where you posted the same question, I suggested another
structure for you.

One of the problems with posting the same question to multiple groups is
that your responses get fragmented, i.e. it limits the way the responses
flow for you.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"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.,