AnsweredAssumed Answered

FM to Web Table

Question asked by JeffYurka on Dec 13, 2011
Latest reply on Dec 13, 2011 by 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

Outcomes