Hi there,
I am creating a database for users out in the field to use when they use parts on fixing products.
What I want to be able to do is having the following in a table:
- Serial Number (of part they are fixing)
- Location (of part they are fixing)
- Parts Used
- Quantity Used
- Part Status (Chargeable / Warranty)
Now for one serial number they may use up to 10 parts of different quantities and different statuses (some may be chargeable, some may be warranty claims). How would I go about being able to enter multiple parts, quantities, and part statuses for each record entry? Would I just have to have Part1, Part1 Qty, Part1 Status (up to 10)? Seems like there might be an easier way?
Any help is appreciated.