Annually we have to inventory capital purchases. The idea is to ensure items purchased (over $1000) are not missing, but also allows us to put an eye on the items in case they need to be replaced or discarded. Each item has a unique barcode on them. What I would like to do, if possible, is once a barcode is scanned, have a form appear with the condition, date, inventoried by, comments. This then would place the info on a different sheet that refs the main list of items. Is something like this possible? Hope this makes sense!
Sure, this is a simple Parent-Child relationship between the Item and it’s inspections.
This template might help you understand
1 Like