Autofill combobox - but with option to change

[Jagged]

Hi


Any suggestions on how to achieve this?

I currently have a form with two comboboxes. One contains a list of products that the user can select from the other contains a list of percentages (sales commission rates).

What I want achieve is that when the user selects a specific product then a specific commission rate is select. However, after selecting the product the user should still have the possibility to select a different rate if that is what has been agreed with the client. Ie. deviate from the standard rate defined by choosing the product.

How can I link the two comboboxes so that the correct rate is selected? while still retaining the the possibility to select something different?

 

[CJ_London]

Not quite sure what you are asking - if you change the 2nd combobox limit to list property to no the user can type in anything they like