FMP7 How to create records from another DB?

[KCT01]

In the abstract, 3 databases are involved.

A has a one-to-many relationship to B.

A has a one-to-many relationship to C.

For a record in A I need to find all related records in B, and create a new record set in C, based on the content of B and other info.

Approach must be Web compatible. How is this done?

If they were merely tables in one DB, I could do it, but this is not an option.

Ken

FileMaker Version: Dev 7

Platform: Windows XP