Put a script trigger (on object modify) on the payment and call a script that can evaluate if it's paid in full and set the status field accordingly.
Thanks for the reply.
I'm a bit of a newbie and wondered if you could point me to a good resorce where I can find actual script language to solve this.
I'm not familiar with exactly how to make this particular script. That is, a script that will set a value list to a particular choice.
You might try defining the Status field as a calculation, like this:
let ( $amount = sum ( related::amountEarned ) ;
if ( $amount > 0 ; "Paid" ; "Open" )
That did the trick.
Such a simple and clean solution.
Thanks so much!