Expression to select a value from a related table based on the value of a column in current table

[Scott_Hall]

I need an expression formula for this:

If the value of the [Waste Category 1] column in the Service Location Repair table is “Bio” then use the value from the [Bio] column in the Service Location table.

This would let me pull the “bio” price from the Service Location table into the Service Location Repair table based on the waste type.

Can anyone help with this? I’ve learned a lot about these expressions but it feels like my appetite for building this app is always a few steps ahead of my ability to build expressions that work.

Thanks in advance.