Prioritising related fields

Discussion created by kylerjphillips on Jan 6, 2016
Latest reply on Jan 6, 2016 by Mike_Mitchell

How does FileMaker prioritise fields that have different values belonging to different related records?

For example


Clients ------< Requests



Take this field for example, if RequestStatus is 'Outstanding' for one related record and for another related record it is 'Withdrawn' - when referring to the client record and using the ::RequestStatus in the relationship field which status would it refer to when there are different related records that have different values?