luvthisboard!
Registered User.
- Local time
- Today, 02:15
- Joined
- Sep 10, 2002
- Messages
- 21
First of all apologies if this is in the wrong section but because I think it encompasses a bit of everything I thought the General section was the best place for it !!.
2nd I have searched and read as many of the stock control posts as possible but nobody seems to be looking to do what I am !!
Ok here goes.
We have just 1 product, each and every stock item of this product has a unique number (sequential)
I want to design some tables/queries/forms etc.. to do the following.
When we get a new batch of stock in, record the details including the 1st unique number in the batch last unique number in the batch which will then calculate how many are actually there (cos they are sequential !). ok thats straightforward and I can do that !
Next !! When a bunch of the stock is sent out to a customer I want the sender to record the 1st number of the batch they received last number of the batch they received, which will then calculate how many they actually got... BUT in order to make sure everything is recorded and to lessen the room for error.. instead of the user manual typing in this info, I want the system to pull from the "stock in" table the next unique number they should be using (hope you can follow this??)
E.g
we get stock of say 50 items numbered 1 - 50 !
1st customer orders 10 they get numbers 1 - 10
2nd customer orders 15 they get 11-26 etc...
I want the system to tell the user that customer nr 2 is to get from 11 upwards
so all stock is totally accounted for, so If I look at the stock in front of me and the next one is nr 21 then the system should tell me the same.
looking forward to your replies !
2nd I have searched and read as many of the stock control posts as possible but nobody seems to be looking to do what I am !!
Ok here goes.
We have just 1 product, each and every stock item of this product has a unique number (sequential)
I want to design some tables/queries/forms etc.. to do the following.
When we get a new batch of stock in, record the details including the 1st unique number in the batch last unique number in the batch which will then calculate how many are actually there (cos they are sequential !). ok thats straightforward and I can do that !
Next !! When a bunch of the stock is sent out to a customer I want the sender to record the 1st number of the batch they received last number of the batch they received, which will then calculate how many they actually got... BUT in order to make sure everything is recorded and to lessen the room for error.. instead of the user manual typing in this info, I want the system to pull from the "stock in" table the next unique number they should be using (hope you can follow this??)
E.g
we get stock of say 50 items numbered 1 - 50 !
1st customer orders 10 they get numbers 1 - 10
2nd customer orders 15 they get 11-26 etc...
I want the system to tell the user that customer nr 2 is to get from 11 upwards
so all stock is totally accounted for, so If I look at the stock in front of me and the next one is nr 21 then the system should tell me the same.
looking forward to your replies !
