Hi
I have a table and I must to populate two combobox with data from this
Example data from my table
The column UF I must to populate in combo1
The column PRODUCT I must to populate in combo2
For this I should make a select distinct
When user click in combo 1
Example 'SP' It should allow to display in combo 2 only the products APPLE and BANANA
But if the user to click in combo 1 in 'MG' It should allow to display in combo 2 only the products APPLE BANANA and PINAPPLE
But the user can first click combo 2, and choose for example PINAPPLE , then in combo 1 Only MG should appear
How can I to Implement this ?
Tia