shared key, find records InOneTable, not the other

[KarlaB]

I have an ID that is used as the key in many tables.

I want to find all records from one table where there is no corresponding record in another table where both have the same key field.

Sorry for such a simple question.

[RalphL]

Have you tried a not equal relationship?

[Ender]

To do this with a simple find, perform a find for the related ID with omit. In a script it would look like this:

Go to Layout [ SomeLayoutBasedOnLocalTable ]

Enter Find Mode []

Set Field [ RelatedTable::PrimaryID ; "*" ]

Omit Record

Perform Find []

[KarlaB]

Interested in a small consulting arrangement?

[Ender]

I don't have the energy to take on another project right now, but you can post your requirements in the Help Wanted section:

http://www.fmforums.com/threads/postlist.php?Cat=0&Board=UBB24

There's bound to be someone available.