Hi all, I'm new to access, running the 2007 version, and i was hoping somebody could help me with something. I work for a company that manufactures ladders and other fibreglass products and ive been assigned with the task of stock management.
What I need is a database where i can enter in all the stock we own and then the different types of ladders we produce and all their components. So every time an order comes in for a ladder i need to be able to select the specific ladder from a list and then have all the relevant components subtracted from the stock list.
Ive had a look around but havent been able to find a template that does what I need. Any help will be appreciated!! Thanks!