8
8l2255
I have a new transaction form. It has fields TransactionID (autonumber),
ProductID, EquipmentID, UnitsReceived and a few more. When I create a new
transaction record I would like the TransactionID, ProductID and EquipmentID
to append new records to the amount of UnitsReceived in my Stock table.
Is it possible for an append query to create multiple new records using
information in the new transaction record and is it possible for the number
of records to correspond with the value entered for UnitsReceived?
ProductID, EquipmentID, UnitsReceived and a few more. When I create a new
transaction record I would like the TransactionID, ProductID and EquipmentID
to append new records to the amount of UnitsReceived in my Stock table.
Is it possible for an append query to create multiple new records using
information in the new transaction record and is it possible for the number
of records to correspond with the value entered for UnitsReceived?