hangry

Create Records from SQL Query

Discussion created by hangry on May 21, 2016
Latest reply on May 25, 2016 by BowdenData

I have Tables A, B and C.

 

I would like to be able to run a query that selects fields from Tables A and B and for each row in the query results create a record in Table C.

 

I know how to write the select query, and if I was doing this in .Net I would create a dataset from the query results and loop through and create a record in Table C for each row in the dataset.

 

Can someone tell me how to approach this in Filemaker?

 

Thanks

Outcomes