kylerjphillips

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

 

Requests::RequestStatus

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?

 

Portal_Clients_Request_Status.PNG

Outcomes