You are correct however we don't really have a lot of data integrity. The last person that had my job before me took the easy way out and put in a cost placeholder for a bunch of options. It is a misc part number that they use in the option instead of adding a new part to the inventory table...
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...
Hey everyone my name is Tanner Whitesell and I am a DBA for a bus manufacturer. Looking forward to learning more about access even though we are transitioning out of it into a more out of the box ERP