Hi all,
I'm looking to create a stock control log where by we can record goods moving in and out of our company. We are a Not for Profit organisation that looks after Video equipment for schools and colleges and so have many items coming for our suppliers and moving to and from various studios. We need to keep track or ALL individual serial numbers. We also have a need to link in test records on this equipment.
The built in inventory DB in Access 2007 is quite good, but I'm sure there would be a way to add a sub-form/table to the "Inventory Transaction List" whereby multiple items in/out can have individual serial number recorded (using a hand-held bar code scanner). Of course, I could just add one line in this table for each individual item received or sent, but this will be time consuming, especially if we have multiple items (or the same type - e.g. 20 specific camera models) move at one time. We don't really need to track re-order levels but again we do need to track where an individual item is and any given time.
On top of this we, test these individual items to make sure they all work properly. These test are relatively simple but are different for each item - e.g. a Camera will be tested for Pan/Tilt (up/down/left/right), Zoom in/out, and focus; whereas a screen may be tested for showing an image at specific resolutions.
I was not sure if I should simply put all possible tests for all items as individual field in a single table, but this would be very wasteful of space. Better (I think) would be to create individual tables for tests and then somehow link these to the sub-table of the "Inventory Transaction List" so that only the correct test will be shown for the item concerned. It guess it would be possible to Use the "Category" field in the "Inventory" table to link through individual items to the correct test schedule.
I'm thinking as I type this how it might be possible, but my first concern is to get multiple entries of same type items with individual serial number working. I am very rusty in this department.
Help please...
I'm looking to create a stock control log where by we can record goods moving in and out of our company. We are a Not for Profit organisation that looks after Video equipment for schools and colleges and so have many items coming for our suppliers and moving to and from various studios. We need to keep track or ALL individual serial numbers. We also have a need to link in test records on this equipment.
The built in inventory DB in Access 2007 is quite good, but I'm sure there would be a way to add a sub-form/table to the "Inventory Transaction List" whereby multiple items in/out can have individual serial number recorded (using a hand-held bar code scanner). Of course, I could just add one line in this table for each individual item received or sent, but this will be time consuming, especially if we have multiple items (or the same type - e.g. 20 specific camera models) move at one time. We don't really need to track re-order levels but again we do need to track where an individual item is and any given time.
On top of this we, test these individual items to make sure they all work properly. These test are relatively simple but are different for each item - e.g. a Camera will be tested for Pan/Tilt (up/down/left/right), Zoom in/out, and focus; whereas a screen may be tested for showing an image at specific resolutions.
I was not sure if I should simply put all possible tests for all items as individual field in a single table, but this would be very wasteful of space. Better (I think) would be to create individual tables for tests and then somehow link these to the sub-table of the "Inventory Transaction List" so that only the correct test will be shown for the item concerned. It guess it would be possible to Use the "Category" field in the "Inventory" table to link through individual items to the correct test schedule.
I'm thinking as I type this how it might be possible, but my first concern is to get multiple entries of same type items with individual serial number working. I am very rusty in this department.
Help please...