tannerwhitesell
New member
- Local time
- Yesterday, 23:10
- Joined
- Apr 7, 2021
- Messages
- 4
Looking for suggestions to make my job a lot easier.
I work for a bus manufacturer and we have an access database to manage all of our production jobs. Each job is made up of options similar to if you would go to build and spec a car at a car lot. Within each option are materials that make up our bill of materials. My job is to update those materials to accurately reflect what we make on the manufacturing floor. However when I am entering the updated materials into the option if the material does not exist in the inventory table then it will throw me an error. Right now I am either using conditional formatting in excel to verify that they exist in the table or searching them by hand in the database. Does anyone know of a better way to paste values into an application or something that I can paste these updated materials in to verify that they are in fact in the inventory table? If they are not in the inventory table I would like to return a PN and then false or have the script run an insert statement to add them into the database. I might just be stuck with returning the value as false because I will have to add cost and vendors etc to the record.
Let me know your thoughts.
I work for a bus manufacturer and we have an access database to manage all of our production jobs. Each job is made up of options similar to if you would go to build and spec a car at a car lot. Within each option are materials that make up our bill of materials. My job is to update those materials to accurately reflect what we make on the manufacturing floor. However when I am entering the updated materials into the option if the material does not exist in the inventory table then it will throw me an error. Right now I am either using conditional formatting in excel to verify that they exist in the table or searching them by hand in the database. Does anyone know of a better way to paste values into an application or something that I can paste these updated materials in to verify that they are in fact in the inventory table? If they are not in the inventory table I would like to return a PN and then false or have the script run an insert statement to add them into the database. I might just be stuck with returning the value as false because I will have to add cost and vendors etc to the record.
Let me know your thoughts.