Insert Name record into TABLE2 if TABLE1 field is Yes.

J

Joe M

If I have two tables, and each table has a field called "NAMES" , eg. Name
of product . What I want to do is to insert the NAME record from Table1 into
Table2 whenever the HAVE field in table1 is "Yes".
So if TABLE1 - 'HAVE' field is "Yes" . Insert this record into TABLE2
also. What's the best way to do this??? Thanks
 
Top