Attached is a quick sketch of a table idea I’m trying to improve. Ignore the naming conventions.
Above the table are dropdowns to select an apple or an orange. The user also has the option to add a percentage to the oranges.
Oranges are sub-categories of the different apples. In my sketch, let’s say that Mandarins and Clementines are always under Granny Smith apples (and that will never change). These 2 types of oranges also cannot be listed under any other apple category.
Easily, to add to the table, the user can select an apple and then select from the list of oranges corresponding to that apple, followed by inputting a percentage.
However, I also want to allow the user to select from the oranges, input a percentage, and have the system be smart enough to connect the chosen orange to its corresponding apple category (when adding to the table).
Assume that the list of oranges is super long (like 100+ types that exist)... So I plan to add an autocomplete to the selection of oranges.
Is there a better way to do this than to keep these existing drop downs and add an autocomplete to the orange drop down?