Products stocks level

  • Thread starter Thread starter Ade
  • Start date Start date
A

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
 
Ade said:
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
Click to expand...

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
 
Back
Top