find the records that have no related records

[Kay]

Howdy,

I have a Contacts file with a related Events file. I want to find the contacts that have no related records, i.e. the folks who have been invited to nothing. Poor fellows. Need to find them. Thanks! Kay.

[Kurt Knippel]

quote:

---

Originally posted by kattatonic:

Howdy,

I have a Contacts file with a related Events file. I want to find the contacts that have no related records, i.e. the folks who have been invited to nothing. Poor fellows. Need to find them. Thanks! Kay.

---

Have a calc field (number) with the following calc: IsValid (RelatedEvents::ContactID).

The result of this calc will either be a 1 or 0, simply find the 0 and you have all those with no related records.

[Kay]

You're a peach!