Use * with an omit request. There's a button to click for manual finds and the omit records script step can turn a find request created by your script into an omit request.
Thank you for the answer but I have been toying with this and cannot get it to work. When I use omit with * it gives me nothing.
The only way I got it to work is to put in the find criteria as follows:
Omit appointment::date > $currentdate
and that is telling me that my relationship is not working properly!!!
I must be missing something basic about relationships and filters through relationships. Is there any ADVANCED reading material about this.
First, if you put a field from the related table that is never empty (such as the foreign key field) on your layout, can you see data in it?
Enter find mode
Enter an * and nothing else into that field.
Click perform find.
If you can't see data in that field, there is an issue with your relationship. By any chance, is the match field an unstored calculation field?