M
Mike
I'm developing Access management database for a Cushion manufacturing company.
I've only learnt basics of Access so i decided to post a question on the
community.
Problem is that there are at least 2 variations when we manufacture a
cushion as the customer's requests are different all the time.
For example, we have a cushion "cover" called #5778 which we keep 500 of
them as a stock. When we receive an order from a customer, we fill them up
with fibre according to the customers weight request and charge them
accordingly.
For example, Customer A may want 100 pcs of #5778 with the filling 500g and
we charge them $2.00
Customer B may want 50pcs of the same #5778 with the filling 750g and we
charge them $3.00
The problem is that if i create a two separate product list as above, i'd
end up with two different raw material as stock (#5778 cover), which doesn't
reflect the correct stock left.
And if I create one product called #5778, then i'll have to enter the weight
and the price everytime the customer places order.
Basically, i'm trying to create a link between "Stock Record Table" and
"Product Table" so that one particular "stock" can be created into various
products at different weight and price.
Please post me some advice asap!
I've only learnt basics of Access so i decided to post a question on the
community.
Problem is that there are at least 2 variations when we manufacture a
cushion as the customer's requests are different all the time.
For example, we have a cushion "cover" called #5778 which we keep 500 of
them as a stock. When we receive an order from a customer, we fill them up
with fibre according to the customers weight request and charge them
accordingly.
For example, Customer A may want 100 pcs of #5778 with the filling 500g and
we charge them $2.00
Customer B may want 50pcs of the same #5778 with the filling 750g and we
charge them $3.00
The problem is that if i create a two separate product list as above, i'd
end up with two different raw material as stock (#5778 cover), which doesn't
reflect the correct stock left.
And if I create one product called #5778, then i'll have to enter the weight
and the price everytime the customer places order.
Basically, i'm trying to create a link between "Stock Record Table" and
"Product Table" so that one particular "stock" can be created into various
products at different weight and price.
Please post me some advice asap!