Automatically Select the Max Value from a Field in a Listbox

[microwin88x]

Hello,

I have the following table:

ID	ID_YEAR	ID_MONTH
1021	2013	May
1021	2013	Jun
1021	2013	Jul
1021	2013	Sep
1021	2013	Oct
1021	2013	Nov
1021	2013	Dec
1021	2014	Jan
1021	2014	Apr
1021	2014	May
1021	2014	Jun
1021	2014	Jul
1021	2014	Aug
1021	2014	Sep
1021	2014	Oct
1021	2014	Nov
1021	2014	Dec
1021	2015	Jan
1021	2015	Feb
1021	2015	Mar

Then I have:

• 1 Listbox with ID_YEAR: 2013 / 2014 / 2015
• 1 Listbox with ID_MONTH: Jan / Feb / Mar
• 1 Listbox with ID: 1021 / 1022 / 1023 / Etc

ID_YEAR and ID_MONTH are part from a Master Calendar table and the ID conforms another table.

What I need is that when I select an ID from the ID Listbox and the ID_YEAR from the ID_YEAR Listbox, then automatically select the last month in the ID_MONTH Listbox for the selected ID.

Do you know if that could be possible?

Thank you!!!

[anbu1984]

Use this expr for ID_Month

=Aggr(MaxString(ID_MONTH),ID,ID_YEAR)