Creating records in a distant table

[Rainy Pass]

The script in the attached file creates records in a table (table two) populating it with some of the data from table one. How can I create child records of table two, in a third table, populated with data from table One?

Any suggestions would be appreciated.

test_2.fp7.zip

[Rainy Pass]

Ok, I solved the problem. File attached.

If anyone has a better idea how to do this I am all ears.

test3.fp7.zip

[Søren Dyhr]

Perhaps not nessersarily better, but slightly different solved:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000686

--sd

[Rainy Pass]

Thanks, I will take a look and give it a try,