Hi anyone that can help
I'm looking at just using a simple access database with a barcode scanner to assign gear to people. I need a way to assign items to people. (For tracking)
I only have 3 tables - inventory, staff and a register table which links the 2 to assign items to staff. (using a PK and FKs).
The barcode scanner can scan a name and then an item which creates a record. The way it works at the moment I need to scan a name for each item and repeat.
I would like it so i can scan (or select) a name. and then keep scanning items assigning them to that person. Until I select complete or similar way to finish.
This should create multiple records assigning each item to that person.
I have looked at multiple different ways online to achieve this from copying text values to temporary tables. Seems that either way i need to write some SQL code and I seem to get stuck.
Is there an easy way to achieve with access? Or the best way to go about this feature.
Cheers!
I'm looking at just using a simple access database with a barcode scanner to assign gear to people. At the moment we dont really have a system in place to manage and track gear.
I only have 3 tables - inventory, staff and a register table which links the 2 to assign items to staff. (using a PK and FKs).
The barcode scanner can scan a name and then an item which creates a record. The way it works at the moment I need to scan a name for each item and repeat.
I would like it so i can scan (or select) a name. and then keep scanning items assigning them to that person. Until I select complete or similar way to finish.
This should create multiple records assigning each item to that person.
I have looked at multiple different ways online to achieve this from copying text values to temporary tables. Seems that either way i need to write some SQL code.
Do you think this is an easy thing to achieve with access? I know its not the best DB software but if I can set something up that doesn't take much time be great. I can send over the database example if that helps - Not much to it at this stage though.
Cheers. Paul