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!!!
