Hello All,
I was intermediate skilled in ms access 10 years ago. But in-between time all my work with access was limited to design some simple dbs. So u can say I am a little out of touch now and could be considered beginner.
I was planning to design app for small general store. (limited to 3 counters).
During writing my work model I was stuck with a little problem.
One way to control prices is manual in which purchaser have to write both purchase price and sale price in product table. I have seen sample databases (Northwind etc) they all use this method.
But I want to set these two automatically. i.e. when stock entered its unit purchase price should amend by dividing bill amount with quantity purchase. I know it is not too hard to modify corresponding fields with new data. but problems come when we have two types of stock of same item. means old lot have different price and new lot have different. I want some way to sell both lots of same item on same time.
I came up with idea that I can let salesman handle this and give him option to select from two prices (price1, price 2 /new, old). I have to find way to handle every lot of same item separately in stock. and need way to automatically disable price2 when its old lot stock becomes zero.
But as I described above I am not a high lvl expert so help me out about this.
Is that only option to do my task?
and what is best way to do that?
And in the end Sorry for a long and newbie question.
Best Regards
nNoor
I was intermediate skilled in ms access 10 years ago. But in-between time all my work with access was limited to design some simple dbs. So u can say I am a little out of touch now and could be considered beginner.
I was planning to design app for small general store. (limited to 3 counters).
During writing my work model I was stuck with a little problem.
One way to control prices is manual in which purchaser have to write both purchase price and sale price in product table. I have seen sample databases (Northwind etc) they all use this method.
But I want to set these two automatically. i.e. when stock entered its unit purchase price should amend by dividing bill amount with quantity purchase. I know it is not too hard to modify corresponding fields with new data. but problems come when we have two types of stock of same item. means old lot have different price and new lot have different. I want some way to sell both lots of same item on same time.
I came up with idea that I can let salesman handle this and give him option to select from two prices (price1, price 2 /new, old). I have to find way to handle every lot of same item separately in stock. and need way to automatically disable price2 when its old lot stock becomes zero.
But as I described above I am not a high lvl expert so help me out about this.
Is that only option to do my task?
and what is best way to do that?
And in the end Sorry for a long and newbie question.
Best Regards
nNoor
Last edited:
