3 Replies Latest reply on May 14, 2010 5:40 AM by philbertgreen

    Trying to populate a field based on a related record

    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