I’m trying to face the best way (if any) of including data from a record of a child table in the parent one. The relation between both tables is one to one (ref: IDFIRST).
I want to create a virtual column with Result in the parent table but can’t figure out how to do it though it must be really easy, i suppose.
The reason I want to do this
I’ve built some Format Rules for the parent table records based on the values of Result (using ANY and Select function) and the system tells me than the rules could slow performance:
The rules are like follows: