Hi,
I have a database with a table tblSTORES and a table tblRECEIVED.
tblSTORES contains a list of existing materials and tblRECEIVED contains newly received batches of materials.
A user enters records of materials into tblRECEIVED usually in groups/batches and these records are recorded using a unqiuely generated 8 digit batch no.
After the user has entered a batch of records I want to cycle down through these newly entered records and run an update query on tblSTORES using the information in each row of this recordset. Is it possible to do this?
I can use a simple select query to get the batch of records that were just entered into tblRECEIVED then cycling through each row of this recordset I want to update the correponding records in tblSTORES based on the information in the current row of the select query.
Can this be done?
Thanks,
Liam
I have a database with a table tblSTORES and a table tblRECEIVED.
tblSTORES contains a list of existing materials and tblRECEIVED contains newly received batches of materials.
A user enters records of materials into tblRECEIVED usually in groups/batches and these records are recorded using a unqiuely generated 8 digit batch no.
After the user has entered a batch of records I want to cycle down through these newly entered records and run an update query on tblSTORES using the information in each row of this recordset. Is it possible to do this?
I can use a simple select query to get the batch of records that were just entered into tblRECEIVED then cycling through each row of this recordset I want to update the correponding records in tblSTORES based on the information in the current row of the select query.
Can this be done?
Thanks,
Liam
