M
Michael
i have a table of products with amount in stock.
i have another table with a list of changes to stock of
products.
i have a form which adds records to the table of changes
i would like the form to update the amount in stock from
the table of products
tblHardware (table of products)
hardwareID (primary key)
hdwInStock (amount in stock)
tblHdwChange (table of changes to stock)
hdwperjobChangeID (primary key)
hardwareID (foreign key linked to tblHardware.hardwareID)
hdjcChangePerJob (amount of change)
Hardware Checkout (form to add record to tblHdwChange)
user can select a hardware and how much they are taking
and a record is added to tblHdwChange. how to i subtract
the amount of change from the amount in stock and update
the amount in stock when the record is added to
tblHdwChange.
i have another table with a list of changes to stock of
products.
i have a form which adds records to the table of changes
i would like the form to update the amount in stock from
the table of products
tblHardware (table of products)
hardwareID (primary key)
hdwInStock (amount in stock)
tblHdwChange (table of changes to stock)
hdwperjobChangeID (primary key)
hardwareID (foreign key linked to tblHardware.hardwareID)
hdjcChangePerJob (amount of change)
Hardware Checkout (form to add record to tblHdwChange)
user can select a hardware and how much they are taking
and a record is added to tblHdwChange. how to i subtract
the amount of change from the amount in stock and update
the amount in stock when the record is added to
tblHdwChange.