I am trying to create a solution to first move data form a FM Plant table to Web SQL Plant table.
Below is the general structure I am working with. I am having no problems with an ODBC connection. I can make changes in the web table fine. But I first need to update the web data form FileMaker. The only solution I can think of because of the table structure is to use a script and loop thru each of the fields in each record and do a set field and use a relationship based upon a global that increments to match the custom_field_id's, 85 there 127.
I was just thinking there must be a better way to move our initial data.
Once the initial data is moved, then I can create the input web fields in FileMaker using portal filters for each of the 43 fields. Then future updates are live.
Custom_Field (43 records)
Title (Common Name, Class, etc)
Order (Sort order)
Visible (show or not show)
Custom_Field_Values (21,731 records)
Custom_Field Plant_ID Value
85 77 Apple
86 77 Class