I have two Access database tables setup. Actually two seperate databases. I need to create a work table out of the main table(table1).

I two datagrids displayed for the two tables and this works.

Now I need do the following
1) delete any records in the worktable
2) copy one field from table1 and create a record for it in the worktable.

How do I do this?

Thanks for any help