4 Replies Latest reply on Dec 13, 2011 2:29 PM by JeffYurka

    FM to Web Table

    JeffYurka

      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.

       

      FileMaker Table:

      Plants

      plant_id

      Description

      CommonName

      Etc

       

      WebDatabase (SQL)Tables:

      Products

      Plant_ID

      Plant_Name

      Price

      Availability

      Product_Images

      Plant_ID

      Image_ID

      Caption

      Custom_Field (43 records)

      Custom_Field_ID (85-127)

      Title (Common Name, Class, etc)

      Order (Sort order)

      Visible (show or not show)

      Custom_Field_Values (21,731 records)

      Plant_ID

      Custom_Field_ID (85-127)

      Value

       

      Custom_Field Plant_ID Value

      85 77 Apple

      86 77 Class