Home
>
WinDev Forum
>
Topic
ComboBox help request
Posted by gga
|
ComboBox help request February 22, 2021 06:47PM |
Registered: 5 years ago Posts: 46 |
I an using WinDev 22 and I have a design problem which I will try to describe.
I want to have 2 ComboBoxes on an Edit Screen where the contents of the 2nd box depends on the content of the first.
The first is no problem: it is linked to a table which describes a type of component 1.Glass, 2. Resin, 3.Labour (and there might be more)
The contents of the 2nd Combobox will be based on either a Glass table, a Resin table, or a Labour table, etc. - a decision determined by what is selected in the first ComboBox.
What is the best way to do this?
Thanks,
Garry
I want to have 2 ComboBoxes on an Edit Screen where the contents of the 2nd box depends on the content of the first.
The first is no problem: it is linked to a table which describes a type of component 1.Glass, 2. Resin, 3.Labour (and there might be more)
The contents of the 2nd Combobox will be based on either a Glass table, a Resin table, or a Labour table, etc. - a decision determined by what is selected in the first ComboBox.
What is the best way to do this?
Thanks,
Garry
|
Re: ComboBox help request February 22, 2021 10:26PM |
Registered: 3 years ago Posts: 107 |
|
Argus
Re: ComboBox help request February 22, 2021 10:27PM |
There is no BEST WAY... there are many ways possible, and the choice depends on all the things you are NOT telling us, including what you prefer, fill more comfortable with...
So, you can, by example:
- Fill the combo by programming, depending on the content of the first combo
- map the combo with a file OR a query by default, along with a filter or parameters, and change the source and filter/parameter values depening on the first combo content
- ...
So, you can, by example:
- Fill the combo by programming, depending on the content of the first combo
- map the combo with a file OR a query by default, along with a filter or parameters, and change the source and filter/parameter values depening on the first combo content
- ...
|
Re: ComboBox help request February 24, 2021 05:00PM |
Registered: 5 years ago Posts: 46 |
It seemed rather complicated getting everything to work in both Edit and Add scenarios but I did come up with a solution which may not be very efficient but works. The tables involved are not very large so efficiency was not an important consideration.
I created 3 ComboBoxes in the same position but on different planes and selected the pane when the user enters that control based on the contents of the previous combobox. The saved values of all the comboboxes are ID's in the related tables so that meant I had an ID in the main table which might reference any of 3 files: using ScreenToFile produced weird results and so I just coded the Save manually.
Thanks for your input.
Garry
I created 3 ComboBoxes in the same position but on different planes and selected the pane when the user enters that control based on the contents of the previous combobox. The saved values of all the comboboxes are ID's in the related tables so that meant I had an ID in the main table which might reference any of 3 files: using ScreenToFile produced weird results and so I just coded the Save manually.
Thanks for your input.
Garry