pcsoft.us.windevCopyright 2026, PC SOFT29 Jun 2016 02:41:00 Z28 Jun 2016 00:06:00 ZHi Everyone. I'm looking for the best practice to resolve the following. I may be missing the obvious…. Data file has 1000+ products of which only +-20 are active at any one time. In a table of e.g.: product records there is a productid linked to a combo control that returns the product name. All possible products must be in the content query to display all possible ids. However. If the user is to select a product for a new record, they must only be able to choose a product that is currently "Active". Ie: select from a shorter list of options. Currently I use two columns, one to display and another as the chooser. The chooser is only made visible in edit mode. I would ideally like the on column to handle the complete scenario. Ie: the dropdown has a different list to whats viewed. thanks Mark30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58379/read.awp29 Jun 2016 02:41:00 ZThanks AL and Fabrice. Lots to try out. I'll get back soon.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58379/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58379/read.awpCombo control - view many but select fewguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58378/read.awp28 Jun 2016 14:44:00 ZHi Mark, just in case you didn't think of that solution already... It should be possible to set the height of each non active…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58378/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58378/read.awpCombo control - view many but select fewguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58359/read.awp28 Jun 2016 14:04:00 ZHello Mark The combobox can return the actual string displayed in the box, its numeric row count or the invisible glink() val…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58359/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58359/read.awpCombo control - view many but select fewguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58351/read.awp28 Jun 2016 05:34:00 ZHI Al Solved the blanks problem. ...wrong link field Not getting the active only list when I load the form. Can load it if …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58351/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58351/read.awpCombo control - view many but select fewguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58350/read.awp28 Jun 2016 04:46:00 ZHi Al I've had a play with gLink ( last week and again now) and looked at all the documentation I can find. It makes no sense…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58350/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58350/read.awpCombo control - view many but select fewguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58349/read.awp28 Jun 2016 02:41:00 ZHello Mark Maybe it only works for memory tables but you can prefill the combobox before you load the table "ExpenseType" is…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58349/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58349/read.awpCombo control - view many but select fewguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58348/read.awp28 Jun 2016 02:01:00 ZHi Al Thanks for response. Not sure I understand you. Combo has Qry_AllProducts set up in the column description.content. …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58348/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58348/read.awpCombo control - view many but select fewguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58347/read.awp28 Jun 2016 01:33:00 ZHello Mark Do you fill the combo before the table loads ? If so just restrict the data before you load the combo with either…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58347/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/58342-combo-control-view-many-but-select-few-58347/read.awpCombo control - view many but select few