Dynamic load of comboboxes with values from database
I need to create an integration service with my database.
I need to load two comboboxes dynamically from a table in my database. User has to pick a year from a list, that contains only the years that I already have in the database and after he pick a year, I want to load another combobox that contains all of the records in the table for the selected year.
Do you have any idea how I can do that? Should I use custom component or a soap web service?
Do you think I can create an empty parameter entity for the years and fill it out on load of my form using a custom component that retrieve a xml data, that I can insert in the entity?
Thank you in advance!