Ive come up up with a few ways to do this that seem a little clunky to me and I have a feeling that there is a much cleaner way to do it.
example, I have a table occurrence "pullSheet" with related "pullSheetItems"
if ( all the pullSheeItems::status = "complete" )
show custom dialog ;" Your pull sheet item are all complete. Do you want to mark this sheet complete?"
set field ( pullSheet::status ; "complete" )
Thanks in advance.