Trigger function on selecting field

[canmarroig]

Hi, i've a a question, 2 fields:

[Table] with a list of value 1, 2, 10, 20

[Last_table] with only one value 1 or 2 or 10 or 20

opening my qwv i want to get a selection: Table = Last_table

I don't understand why my trigger function

Table   =max({1}Last_table)

is wrong, what can I do.

Tks

[sunny_talwar · Accepted solution]

What if you just do Last_table (without max)

[avinashelite]

have you used the on open trigger or field event trigger ??

create a on open trigger and try you expression this should work , check the field names once

[canmarroig]

I don't understand: i've applied the same function as suggested by Sunny:

select in a field -> Table  =Last_table

1) on a button action:  it's correct

2) on a open document trigger:  it doesn't run

Why

[sunny_talwar]

Would you be able to share a sample showing it isn't working?

[Joaquin_Lazaro]

Try this

Table   = Only(Last_table)

[canmarroig]

There's another action: selecting one sheet, I have to keep this after table selection not before.