Great insight needed!!
Good evening everyone.. I've come to a point where I can't even fathom how to go forward.
I'm attempting to create a serialized inventory. I don't know where to begin.
I need to keep a running inventory of serials by customer, by model and then by serial.
Customer 1>Model1>Serial1
I can get that far within a database using relationships... It now has to do with adding and removing them from the active inventory.
I could run a series of update/append/delete queries. Use an append query to add items to the inventory, a delete query to remove. The delete query being used on the 'Shipment' form, the append being used on the 'Receive' form.
That seems simple, but now here is the part that makes it tricky. Not all the Models have serial numbers, only quantities. To explain, I will demonstrate a scenario using more common things than I actually deal with; an office store for instance.
The office store has pencils, paper, computers and printers. The pencils and paper would not have serial numbers, but would still need to be kept track of using quantity. The computers and printers would have serial numbers.
I would run a delete query everytime I shipped a computer or printer where the serial number equaled the one in the customer inventory. I would run an append whenever a serial number came in. I would also have a stated quantity that should (theoretically) never deviate from the count of serialized inventory.
Just speaking of it is confusing me, perhaps because I've been working with this database for the past twelve hours, or just because it's complex.
If anyone has some insight, or maybe just some tips, I would appreciate it.
I've taken a look at Allen Browne's inventory system and am using it as a sort of guide..
