pcsoft.us.windevCopyright 2026, PC SOFT10 Apr 2015 22:17:38 Z27 Mar 2015 20:55:49 ZHello, I am trying to find the best way how to fill combobox with Employees names of certain Company. I have 3 database files. ORDERS, COMPANIES, EMPLOYEES. I have a window with quite typical layout - on the top is Table, below are fields, Table and fields are linked to ORDERS. When you click on a table row (each row is one order), fields are filled with appropriate data from ORDERS, COMPANIES, EMPLOYEES. I use linking from visual editor. Please see a picture of my window. http://hostimage.windev.io/images/Window2_6b1cea98f2efc6c9c18d6581235dd967.jpg I have a problem with combobox with Employee name. I want to fill it only with Employees from selected Company. For example: You select some order, this order contains Company called "Tiskap" and this company has 5 employees. But as you can see on my picture, combobox is filled up with ALL Employees of all companies. So question is how to fill combo with Employees only from "Tiskap". Of course it must work when you click on another order with another Company, combobox should be filled with Employees from that another Company. Combobox is now linked also via visual editor with multi-file linking. I probably need something like "SELECT Employees.FirstName, Employees.Second FROM EMPLOYEES WHERE EMPLOYEES.KontaktID=COMPANIES.KontaktID"... I hope I am clear enough and that somebody will help me. Thank you Regards Petr30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)PETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51470/read.awp10 Apr 2015 22:17:38 ZSo, final solution with help of Fabrice is like this. There was a lot of small but important details to tune. Also, one importan…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51470/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51470/read.awpHow to fill combobox from databasePETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51387/read.awp7 Apr 2015 10:26:27 ZHi Fabrice, I am sorry, I probably explained myself wrong. I meant selecting code by user not by code. When USER select di…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51387/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51387/read.awpHow to fill combobox from databasePETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51339/read.awp3 Apr 2015 16:22:57 ZFor now I will try to live with this code placed under TABLE event "Selecting a row of TABLE_Orders". [code:wl] HFilter(FirmyK…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51339/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51339/read.awpHow to fill combobox from databasefromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51338/read.awp3 Apr 2015 16:16:31 ZHi Petr you are just making a common mistake... All these event are USERS event, not program/code events... So if you se…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51338/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51338/read.awpHow to fill combobox from databasePETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51337/read.awp3 Apr 2015 14:30:30 ZHi Fabrice, thank you for your answer. Among the others I also tested this event "Selecting a row of ..." already before but…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51337/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51337/read.awpHow to fill combobox from databasefromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51324/read.awp2 Apr 2015 15:18:04 ZHi Petr, You will put your hfilter in the code where the users changes the condition... So it depends of your UI... In a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51324/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51324/read.awpHow to fill combobox from databasePETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51323/read.awp2 Apr 2015 14:53:30 ZHi, I did tests, and for now I will stick with option 2 and I will see how it works during next development. So thank you aga…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51323/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51323/read.awpHow to fill combobox from databasePETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51273/read.awp31 Mar 2015 14:29:58 ZThank you Fabrice, I will examine these ways and I hope I will be satisfied. WinDev is new for me and it is still difficul…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51273/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51273/read.awpHow to fill combobox from databasefromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51272/read.awp31 Mar 2015 14:09:34 ZHi Petr, unfortunately, there is no BEST way... Only different ways that you can use, and mostly it's a question of choice.…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51272/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51272/read.awpHow to fill combobox from databasePETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51266/read.awp31 Mar 2015 12:17:28 ZPETR_K wrote: Hello, please is here anybody who could point me in a right direction? I have quite a lot of these combos …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51266/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51215-how-fill-combobox-from-database-51266/read.awpHow to fill combobox from database