I have a challenge of copying some records from two tables of one database to the two tables (of the same name) in another database. Here is why it is a challenge.

The table names are:
PM_CATEG - Categories which has a PK field PMCATEG_PK
PM_TASK - PM Tasks which has a PK TASK_NO (Identity) and PMCATEG_PK (set matching the PMCATEG_PK in PM_CATEG table).

Example:

PM_CATEG
CATEGORY     PMCATEG_PK
PUMP              10

PM_TASK
PMCATEG_PK               TASK DESCR    TASK_NO
10                      List of items       200
10                      Another list        201
10                      Another list        280

(Note that the TASK_NO is not always sequential because it could have been created at different time).

Now I need to copy the records from PM_CATEG and PM_TASK of one DB to another for CATEGORY = 'PUMP'

I would use the INSERT command but I have to dynamically INSERT into the PM_CATEG and then using a newly created PMCATEG_PK copy the PM_TASK.

Is this possible or I am better off creating a VFP PRG to do it?

TIA