In a relation (related thru a like this. a::field_1 = b::field_2) two table are connecd. Table "a" has more recored then table "b". Therefore in table "b" appear some records as empty, because no relation can be established (like in a full outer join on any SQL DB). When I perform an interactive find and put an * in b::field_2 then I receive all related records (inner join). Then I select omit for the current found set and I recieve all records which have no relation, since they do not exist in the other table.
This is what I would like to achive through a script. Unfortunatelly may attemp to script this behavior repeatently fails.
Enter Find Mode
Set Field [b::field_2;"*"]
Perform Find 
Show Omitted Only
I receive always all recored instead the subset which I receive when I do it interactive as described before.
Does anybody has an idea what I do wrong? Thanks for your help.