Append Queries and how to use them to update tables

  • Thread starter Thread starter Eddie
  • Start date Start date
E

Eddie

So I have this database, and Ive been told here to use an
append query to update my data from my filter table/form
to my actual inventory table/form. Im assuming I would
then use a delete query to nuke all the data in the filter
table/form, as it would no longer be necessary. I would
link both of these queries to a button, with the append
acting first, then the delete. I get that (i think).

Part 2 of my problem is that from the inventory table/form
I want to select individual records displayed in my form,
and then append/delete those to a shipments table/form.
What I dont understand is how to build the statements to
make sure that its only copying the records that I want.
For instance, I have an inventory with warehouse tag 123,
model number XYZ, and serial number 987. I want to make
sure it verifies all 3 of these before copying the record
from inventory and nuking it out of the inhouse system.

After the entire thing goes through its process, I would
probably add the statment Update.FormOutgoing and
Update.FormInhouseInventory to get them to auto refresh...

I imagine its a simple where statement... but Im stumped
and need help.

Any takers?
 
Eddie;

This worked for me last night.
252813 ACC2000: How to Automatically Subtract a Quantity Ordered from Your
Inventory

Go to Microsoft.com and search for the above.

Andy
 
Back
Top