Adam AIS Posted April 17, 2010 Share Posted April 17, 2010 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! Link to comment Share on other sites More sharing options...
bruceR Posted April 18, 2010 Share Posted April 18, 2010 Yet another application for the Virtual List technique. CSV_Portal.fp7.zip Link to comment Share on other sites More sharing options...
Adam AIS Posted April 18, 2010 Author Share Posted April 18, 2010 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5145 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now