How to associate two comboboxes

[gerardo.mottini]

Hello.
I have two combobox from the same table in a Forms.
How can I connect them so that when one changes then the other changes as well?
Thank you.
Sorry for the bad English.

[Ratslinger]

Hello,

I believe list boxes may be preferable. You do not state if these are in a table control or not. If so a more difficult issue. Please see:

How to use user selected value from combobox1 in combobox2 'SELECT' statement

I have the following reference table (treatment) - extract as follows: [image description] On a form, to record treatment for an animal (dog) in table “dog_treatment”, I have 2 combo boxes, the first to select ‘treatment_type’ (SELECT DISTINCT (“treatment_type”) FROM “treatment”) and the second ‘treatment_subtype’ (SELECT DISTINCT(“treatment_subtype”) FROM “treatment”). Obviously subtype is dependent on the first selection (type) and I would like to use the value selected in the first combo bo…

and

Libreoffice combobox filtering

A combo box is just a text box with auto-complete. It writes into the undelying text field whatever you type into it regardless of the list content. If it is about primary keys and foreign keys, you always want a listbox. A list box shows a column of text values and writes the corresponding key into a foreign key field (typically an integer). Cascading listboxes are a little bit complicated. The attached database lets you find a city by its continent and country. The selected city can be passed…