should this work - set field (information::check number;open payables::check number + 1
Such a script step may work or fail depending on the table occurrence "context" in place at the time the script step is executed. If the current layout is based on either information with a valid relationship to the correct recrod in open payables or based on open payables with a valid relationship to the correct record in information, then it will work. If you are on a layout where neither of these is the case, it will fail.
just figured my error - the calculation does work - sometimes i get hung up on a script thinking it should work in filemaker when it doesnt - just wanted to make sure this script worked in filemaker - thanks
Retrieving data ...