PerryL7 Posted March 3, 2006 Posted March 3, 2006 (edited) 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 Posted March 13, 2006 Author Posted March 13, 2006 I got it working. I had to use a global field to store the value and created a relationship between the two tables.
Recommended Posts
This topic is 6846 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now