Need help with expression

[Switchoffthelight]

I'm struck trying to label features in fieldrun layer with a value from the fieldshot layer. Each fieldshot has an ID that links to fieldrun and I'm stuck because I have one fieldshot for fieldrun and the id is null. I need to get the display_field from a fieldshot and have it show as a label for the fieldrun. Hope this makes sense and I hope someone can help me find which expression is best to use in qgis?

 

[Forgotten_Wealth6]

Have you tried using a "relation" in QGIS project properties to link the fieldrun and fieldshot layers based on their IDs, and then using an expression like relation_aggregate('your_relation_name', 'max', 'display_field') in the fieldrun layer's labels?

 

[sensedfromabove761]

Great idea! If you use a relation with relation_aggregate(), you'll really have the upper hand in grabbing those values from the linked layer. It's definitely the way to go