Trying to populate a field based on a related record
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.