Products stocks level

[Ade]

Clear DayI'm using the Northwind sample database. How can I link Quantity
field in Orders Details subform with the stock level in Product table so
that every time I make orders and input some quantity in the orders form,
the same amount will be deducted from the products stock levels.
Kindly help if you can.
Regards
Ade

 

[Marc]

Clear DayI'm using the Northwind sample database. How can I link Quantity
field in Orders Details subform with the stock level in Product table so
that every time I make orders and input some quantity in the orders form,
the same amount will be deducted from the products stock levels.
Kindly help if you can.
Regards
Ade

If you open Access, it asks you if you want to use a recent file, an
existing file, create a new empty db or use a wizard.

Click the wizard, then choose the inventory db. Then merge the parts you
want into the NWind db. There is a bit of work involved, but the basics are
all there.

HTH
Marc