I am using FM 12 03 Advanced

 

I have the script above.  it is supposed to produce a report that shows all the DECEASED (DOP) members Omitting the deceased members whose spouses are also deceased.

 

Leaving out the OMIT RECORDS second part of the FIND works.  But, when I add the Omit .... part it fails.

 

DOP is a date field that holds the deceased member's date of passing.

 

I also have a SpouseDeceased field that holds "Yes" if a checkbox is checked.

 

The script above seems like it should work.  But, of course it doesn't. 

 

What am I doing wrong?

 

Thank you

 

Ron

 

Try using a constrain found set rather than just a find for the omit.