AnsweredAssumed Answered

Trying to populate a field based on a related record

Question asked by philbertgreen on May 14, 2010
Latest reply on May 14, 2010 by philbertgreen

Title

Trying to populate a field based on a related record

Post

Hi,

 

Would really appreciate some help with this as I'm a bit stuck at the moment.

 

I've got two tables, one called Manuscripts and another called Submission. There is a one to many relationship between Manuscripts and Submissions. I want to add a boolean field to Manuscripts that sets to TRUE if there are related records in submissions, AND one of the related records has the field of Status set to pending. 

 

If anyone has any ideas I'd be very grateful as I've been going around in circles with this for a while. 

 

Thanks,

 

Phil

Outcomes