How do I add / print line numbers on an invoice.
I have a normal setup for our order database. ie a table for customers 1 for orders one for line items etc.
every thing work fine but I now need to ad a line (item) number to the invoice. ie
1 part number price
2 part number price
3 part number price
4 part number price ...
How can I add an incremental number for each line. Obviously the number has to start again at 1 for the next order. I do not neccesarily need to record the line numbers they could be generated during the print but if I remove a line the numbers should not have gaps.
Thanks in advance for your assistance.