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.
Hello, I have been a programmer with over 12 years experience. Would love to go over the specs for this application with you. Am ready to start work on this tomorrow. Are you set on making this an Access app or o Daha Fazla
3 freelancers are bidding on average $1000 for this job
Hello, Thanks for providing us a chance to bid. Please check PMB for details. Regards, Naveed
Hi, I've very good experience in Access database. I can provide the solution to add/update/view inventory data by multiuser and from different locations. I can provide a very easy to use interface for data input and Daha Fazla