combo box

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create append query resulting in multiple new records 4
calculation based on previous record 0
Update checkbox on all but most recent Transaction 1
Calling TempVariable's value in an Append Query 1
Use of Max is quite working 3
Before, current, and ending units based on dates 2
Moving data into a new table once selected from a form 9
filtering for groups of products 1

Top