Automatic set values in other fields when select a value of another field

[francisvandergr]

Hi

I attached an qvw of what i want. It is an example with a few data.

What i want is when i select accounts or invoices also year 2012 is selected and no month
When is select orders no year must be selected but only month Jan

How can i do this with a trigger ?

[whiteline · Accepted solution]

Hi.

You can use 'OnSelect' trigger (Document properties->Triggers) for that fields with 'Select in Field' actions.

[francisvandergr]

Thnx for your answer. But i am looking for the formula of such a trigger. I know i can use triggers

[francisvandergr]

Thnx for your answer. But i am looking for the formula of such a trigger. I know i can use triggers

[whiteline]

If you just want to make an expression that calculates as if year 2012 is selected when you select account, you could use set analysis feature.