Copy Records From MySQL Data to another Table in Filemaker Solution

Discussion created by raykennedy on May 17, 2016
Latest reply on May 18, 2016 by monkeybreadsoftware

My solution uses data sourced from a MySQL database. I would like to copy selected rows from that MySQL data and add to another table with identical fields in filemaker. The MySQL data is only being used to view the data in the filemaker solution and is changed dynamically every hour (for other purposes) so changing the data in that imported data is not an option for this particular solution. The data has roughly about 320 fields. I am looking for what maybe the most efficient way to copy each individual record over to a table in the Filemaker solution. Right now it will be based upon user selecting the rows they would like to copy such as an button script.