Skip to main content
adriana0262
New Participant
Jun 13, 2025 4:31 PM UTC
Question

Custom Record Field, one to many relationship, pick one

My situation is as follows:

I have a Vehicle record, an Employee record and a Driver mapping record between them. A vehicle can be reserved by a driver at a time, but in it's history there can be many previous drivers. I want to make a custom record field that shows the current driver assigned to a given vehicle so that i can use it throughout my application. However I am not sure how to do this with the aggregated custom fields. Since aggregations basically do not care for the specific thing i want (I want to show the employee name of the driver that has the latest start date on the mapping table).

Is there anything i can do for this? Or do i just have to rely on relationships and generally querying relatedRecordData appropriately to satisfy this situation? 

3 replies

stefanhelzle0001
Brainy
Jun 13, 2025 4:34 PM UTC

Do you need this custom record field for any specific purpose? If not, querying related data is probably the more simple approach.

adriana0262
New Participant
Jun 13, 2025 4:54 PM UTC

mostly just showing it on the summary view of the vehicle and any ohter places that might come up. I have had this same pattern come up before and i couldn't really figure out a way to use custom record fields for it, so I am trying to ask here now to see if there is some way to do so. 

stefanhelzle0001
Brainy
Jun 13, 2025 5:11 PM UTC

For such things, I typically create a separate query expression composing the output from various records.