Experience Have done application programming as well as some installation and administration mostly with MySQL for web servers and site development and also with IMS and DB2 on legacy systems in the past.
Question Hey Marty,
I have Microsoft Access 2003 and I need to create a database that will store all of the projects and tasks for a particular item number. Additionally, this database will need to store the location(row, rack and bin [separate categories]) for where these items are located.
For instance, if someone has a job and it requires them to use item no. 123. Ideally, they should go to this database and input the item number, then a screen should pop up or a display window should show up asking the user, which project and task goes with this job. When the user inputs the project and task, another screen pops up or display window shows up telling them where the location is for this item number.
This is an inventory database because, the user needs to input how much of this product they are using, so it can be subtracted from what's on the database. Do you have any ideas on getting this implemented? Thanks
Answer Jay,
This involves the development of an application. What I mean is that you can input the inventory items on one table, then the jobs, including which inventory parts they need on another table.
But to coordinate between those two as you describe will need a program written so that the tables can be updated. It can get involved, depending on how automated things need to get.
Let me know more such as the number of inventory items and the number of jobs possible and how different users will access this for a better idea of the effort involved.
