append qry - insert record

[shelspa]

I have two tables: tblFormulations and tblWP
The records in the first are unique to the field: FormulationsLot.
The records in the second are unique to WPLot.
These two fields have identicle values. When a new record is generated in tblFormulations, I want a new record to be appended to tblWP with WPLot equal to FormulationsLot. No other fields need to be populated. Do I create some kind of append query which is run during data entry into tblFormulations?

 

[PHV]

You may consider something like this:
INSERT INTO tblWP (WPLot)
SELECT FormulationsLot FROM tblFormulations
WHERE FormulationsLot Not In (SELECT WPLot FROM tblWP);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244