boophoenix
Registered User.
- Local time
- Today, 05:21
- Joined
- Jan 10, 2010
- Messages
- 18
In my line of work it isn't uncommon to have an open invoice for long periods of time with the need to add items as time passes. The problem I have ran into along with a couple of friends is if needing to add an item in say the middle of existing items. And to save and print with the new item in this location you have to erase all of the following data and reenter it.
Invoices may have one item or one hundred so erasing to the point of adding a line isn't a time valuable way and leads to possible error in inputing the data again.
The table colums InvoiceNo, LineID, and Line are the main sorting fields it appears then the rest of the fields. I am just in the early stages of trying to get this started and would like to design this in the proper way from the start. I kind of understand the relationship of each field at the novice level, but if I can delete one and keep on trucking why can't I add one?
Hope this makes it since once posted. I tried to preview it before posting and get I'm not logged in, but says on this page I'm logged in as me .
Invoices may have one item or one hundred so erasing to the point of adding a line isn't a time valuable way and leads to possible error in inputing the data again.
The table colums InvoiceNo, LineID, and Line are the main sorting fields it appears then the rest of the fields. I am just in the early stages of trying to get this started and would like to design this in the proper way from the start. I kind of understand the relationship of each field at the novice level, but if I can delete one and keep on trucking why can't I add one?
Hope this makes it since once posted. I tried to preview it before posting and get I'm not logged in, but says on this page I'm logged in as me .
Last edited: