I need an inventory location query with multi user capability.
We are a small auto parts warehouse. Inventory is currently kept in an Excel file, with columns titled 'Location', 'Part Number', 'Vendor Part Number', 'ID' (identifying number of person who put it there), 'Quantity', 'Note' (text note), and 'Date' (date put in that location). The obvious problem is that only one person can make changes to this file at one time, and as inventory changes throughout the day, other users cannot see the changes.
I want to have a database with an interface that will display the information in each field upon a search by any of the fields, and have other users on the network (local) be able to make changes to the database via the query.
Location values are, for example, A 1-1, A 1-2, A 2-1, and so on. A 1-1 would be rack A, shelf 1, position 1. Location A 1-1 will have more than 1 item in it, and the part numbers will be different.
If you can do this project, I'd love to hear from you.