Many to One Relationship Search

[PerryL7]

I have a many to one relationship between two of my tables. Specifically, I have one person that can have multiple letters associated with them. I have a script that sends that person a letter as long as they meet the following: they have not been sent this particular letter before. As I loop through my people table I want to run this check. How do I handle this? Should I do an IF statement like:

if(not(Letters::ID = Contact Info::ID and Letters::Description = "Initial Letter"))

I have been unable to get this to work. Thanks for the help.

Edited March 3, 2006 by Guest

[PerryL7]

I got it working. I had to use a global field to store the value and created a relationship between the two tables.