Hi everyone I am struggling with expressions...

[XJH_GOV]

Hi everyone

I am struggling with expressions. I have the two following columns :

B

14499

A

12000

B

14499

A

12000

A

12000

B

14500

B

14500

A

10001

B

14500

A

10001

C

9200

C

9200

In a new form, when I first select B, I want the “INITIAL VALUE” of column n°2 to be 14500 (the last value linked to B). Is it possible with a combination of MAXROW / SELECT ? Or maybe a TAB with a FILTER but can’t put the tab name as a variable in expressions ?

Thanks for any advice