This might be so simple, but i have not been able to get it done.
I have created a new Dashboard which is working great pulling information from APInvHed table. I created to epiUltraCombo fileds to work as “filters” and manually added a list of Years and Months for the user to select the desired ones. In case of the months, there is no problem, since there will always be 12 months, but in the case of the Years, there will always be the need to update the list to show the “new” year every end of year.
I have created a very simple BAQ to the APInvHed table, showing only the “Group” of FiscalYear field. giving me the desired results, of years from the begining of company operations to todays date.
is there a way to populate the epiUltraCombo with that information instead of “hardcoding” the epicombo list?