I'm working on taking data from an external mySQL data source and formatting it into a format I can use and display in FileMaker. The main table has two fields "items" and "ref_number". The field "items" uses CSV to list the items with a format of item name, quantity, for example:

item one, 1, item two, 1, item three, 5, item four, 2,

I'm trying to come up with a way to calculate this data into a related table to display the items in a portal (traditional invoice style). It would need to create a record (related to the original based on "ref_number" for portal purposes) for each item and set the field "item_name" with the item name and the field "item_qty" with the quantity for each CSV entry.

Any ideas? I've searched around this forum and the web without much luck. Seems like all of the CSV functions are for importing a CSV text file.

Thanks!

Yet another application for the Virtual List technique.

CSV_Portal.fp7.zip

Bruce,

Awesome! Thanks. I'll do some research on the virtual list technique and take a look at your scripting. Thanks a lot for the example file!

Adam