You are correct. There are too many fields. I do not like this structure and believe it is incorrect. However, I am a small fish in this pond so for now I cannot change it. I meant to show the qty for item for also. I just forgot to put it in there. I was using vdf as a "description" I got...
Hey lbass,
The way the table is set up that would return one product when multiple may have been purchased.
Examply table columns
Cust. Name
Cust. Number
Send Date
Item 1 description
Item 1 QTY
Item 2 description
Item 2 QTY
Item 3 description
Item 3 QTy
Item 4 description
Item 4 Qty...
Hi all I am trying to create a report that shows an order. The database structure is not exactly how i would like it so here is my challenge.
I bring the purchaser info at the top.
Now I want all the items and qty. ordered.
The problem is I only want to show when there is an order not...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.