How to display the Different Field if i select Different Field from list Box

[gopikrishnach]

I want 2009 is the result from List box 2, if I pick 2006 from List Box 1. How?

List Box 1	List Box 2
Year	Year
2005	2009
2006	2010
2007	2011
2008	2012

[gopikrishnach · Accepted solution]

First need to create one state from alternate state. Assign the created state to List Box 1.

Go to field event triggers=>Add Action=>Select in Filed=>Filed as 'Year=>Search String as '=Max(Year)+3=>OK.

Then if you select 2006 from List box 1, automatically the result will be 2009 in List Box 2.