Hello,
I'm starting a new project for my department that basically needs the following features:
Track current inventory for department uniforms(pants, dress shirts, t-shirts, etc)
Track current inventory for personal protective gear(ppg) (helmets, pants, coats, gloves, etc.)
Track inventory & ppg assigned to employees
Record employee sizes for both uniforms & ppg
Record issue dates for any uniform or ppg issued and to whom
Record any maintenance done to ppg, what was repaired etc. and the date
Record all replacement uniforms or ppg issued to employees
I was looking to get some input for any direction as to possible table structures, relationships and any other pertinent info some of the more experienced can suggest prior to development. I'm in the pencil and paper stage listing fields, and possible queries/reports.
Any insight appreciated,
Jim
I'm starting a new project for my department that basically needs the following features:
Track current inventory for department uniforms(pants, dress shirts, t-shirts, etc)
Track current inventory for personal protective gear(ppg) (helmets, pants, coats, gloves, etc.)
Track inventory & ppg assigned to employees
Record employee sizes for both uniforms & ppg
Record issue dates for any uniform or ppg issued and to whom
Record any maintenance done to ppg, what was repaired etc. and the date
Record all replacement uniforms or ppg issued to employees
I was looking to get some input for any direction as to possible table structures, relationships and any other pertinent info some of the more experienced can suggest prior to development. I'm in the pencil and paper stage listing fields, and possible queries/reports.
Any insight appreciated,
Jim
