Remote MySql table copy/lookup value from local table
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?