Hi!

I've got 2 tables.

Table 1 contains all enrollments for each student. This is the master of the 2 tables.

Table 2 contains a subset of those same enrollments for each student.

GOAL: To have a calc field in Table 1 that shows TRUE when a matching record exists in Table 2.

I have established a predicate relationship between the 2 that is based upon the concepts of a self-join duplicate record identifier. IOW, I have about 6 fields that I match between the 2 records to ensure they are indeed identical. I did it this way because, though each enrollment record is uniquely identified, those IDs are not identical between the 2 tables.

I tried the following formula, but no joy:

not IsEmpty ( Table 2::ID )

Any suggestions?

Steve
--
Steve Willis
stevewillis at mac.com

An artist is not paid for his labor but for his vision.
James McNeill Whistler


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/