Dynamic Values

Hello All,

Just trying to think this through. I’ve got 2 Tables in a DB.

Table A is normal Blood Reference Ranges - here, Test, Gender, Low, Hi, Measure

Table A
Red cell count (RCC), Male, 4.5, 6.5, 109/L
Red cell count (RCC), Female, 3.8, 5.8 109​​​​​​​/L

Table B is a result - so Date, Result, Measure

Value Set as Male

Table B
01/01/2022, 5.4, 109/L
02/02/2022, 3.1, 109/L

You’ll see that the second entry above falls below the normal blood values for a Male, Low (4.5), High(6.5)

What do I need to think about in terms of getting

Table B to show a red background on results that fall below LO, Male in table A?
Table B to do something - ie. activate a Warning Model or send an email when the above is triggered?

So if value B falls =< or => than Lo, Hi in A, then do something.

I’m just not sure of the pieces I need to put in place to make this happen.

Any pointers anyone?

Cheers
M