AnsweredAssumed Answered

Remote MySql table copy/lookup value from local table

Question asked by blahblahblah on Feb 16, 2011

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?

Outcomes