Hi
I consider myself a reasonable Access user - but am certainly not a programmer.
I'm trying to write an inventory/stock control database (or modify an existing one) - I wrote one a few years ago but it was v clunky so want to improve this time around!
The system needs to record component parts, which can be assembled into products, which can then be assembled into kits. Goods inwards will usually be components, but goods outwards could be either components, products or kits. I don't need any kind of 'sales' interface as the goods outwards all go to a single place.
I also need to maintain stock levels/reorder levels etc, whilst allowing components to be provisionally allocated to jobs, only taking them out of stock once they are officially work in progress.
I've had a look at the MS Access Inventory template but am not sure its going be something I can amend to do what I want (it looks complicated?) or whether I am better to just start again.
Help! Any advice/guidance appreciated?!
Lynda
I consider myself a reasonable Access user - but am certainly not a programmer.
I'm trying to write an inventory/stock control database (or modify an existing one) - I wrote one a few years ago but it was v clunky so want to improve this time around!
The system needs to record component parts, which can be assembled into products, which can then be assembled into kits. Goods inwards will usually be components, but goods outwards could be either components, products or kits. I don't need any kind of 'sales' interface as the goods outwards all go to a single place.
I also need to maintain stock levels/reorder levels etc, whilst allowing components to be provisionally allocated to jobs, only taking them out of stock once they are officially work in progress.
I've had a look at the MS Access Inventory template but am not sure its going be something I can amend to do what I want (it looks complicated?) or whether I am better to just start again.
Help! Any advice/guidance appreciated?!
Lynda