ExecuteSQL ( "SELECT Count ( Status ) FROM pullSheetItems
fkPullSheetID = ? AND
lower( status ) <> 'complete' " ;
"" ; "" ; PullSheet::pkPullSheetID )
If the count returned is 0 Then the current Pullsheet record does not have any pullsheet items not marked complete. You may also have to check for the possibility that there are no related pullsheetItems.
If without SQL
If [ ValueCount ( FilterValues ( List ( pullSheetItems::status ) ; "complete" ) ) = Count ( pullSheetItems::fkPullSheetID ) ]
As phil wrote, you'd want to exclude the case both are zero.