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
 

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

Top