0 Replies Latest reply on Feb 16, 2011 2:31 PM by blahblahblah

    Remote MySql table copy/lookup value from local table

    blahblahblah

      Title

      Remote MySql table copy/lookup value from local table

      Post

      ok i got a remote mysql table in filemaker and i need the remote  product table to look up or copy "quantity in stock" from the local  product table.

      i would like it to do without a script and already  tried doing it via calculation or lookup but it does not make the value  appear in the remote table like one would expect. the quantity field in  the remote mysql table options are: "Auto-enter Calculation replace  existing values Always validate Numeric only"

      the local field quantity in stock is a calculation

      maybe its a bug or does it take a while to update?

      is there a way to run a script upon the event of a calculated value changes?