copy multiply records to the same table

[a123]

I would like to copy (not duplicate) multiply records from a table to the same table and some of the new fields would have same values as the original ones. The table fields are:

1. ID - auto-enter serial

2. Name - text

3. CategoryID - number

4. L - number

5. N - number

For example I have records with 10 different categories and I would like to create a new category (with ID=11) and copy all the records from category 3 to category 11.

The fields 2.Name and 5.N should have the same values as the values from category 3, but the other fields (without 1.ID and 3.CategoryID) should be entered manualy. The field 3.CategoryID should be set by script. Is there any way to do this with script in FM?

[aaa]

Your script must:

Find all records with Category_ID=10

Duplicate records

Then do with duplicated records what you want.