I have a table for workorders(WO). The workorder ID is unique. Each WO can have one or more labor/repair operations (e.g. oil change, clutch, radiator etc.) which I have named WOItemNo. I would like the tech to be able to enter multiple repair items and have them start at item 1 (by default value of 1) and any additional entries to progress for each entry e.g. 2,3,4 etc. on each WO.
How can I get the items to be progressive. All the entries are made on a form. Or should I have a seperate table with the itemized records connected to the WO table? Again how do I get the item # to go from 1,2,3,4,5 etc. on each WO?
Thanks!
How can I get the items to be progressive. All the entries are made on a form. Or should I have a seperate table with the itemized records connected to the WO table? Again how do I get the item # to go from 1,2,3,4,5 etc. on each WO?
Thanks!