Hi all, I have two comboboxes: one picks a part number and he other one brings up an ordercode which is dependent on that part number originally selected. So, for example, I could pick an HCPL-0600 in the part number combo which then automatically in the second combo *only* brings up the possible order codes for that part number. In this case, both RS and Farnell might stock exactly the same part, but have completely different order codes. This is easy to do and works fine. *However*, what I'd like to do is use a *third* (supplier) combobox to filter out the order code(s) so that only the ordercodes for that particular supplier are in the combobox.
I can put the following in the filter field of the ordercode combobox: supplier_number=6 In my case, supplier number 6 is Farnell and that works a treat in that when I go to HCPL-0600 in my part number combobox, the only option in the ordercode combo is the Farnell order code. What I would like to do is something like this: supplier_number= suppliercombo.supplier_id supplier_id for Farnell, as I said, is 6 and that is chosen as the listcolumn in the suppliercombo combobox. Now, the above doesn't work and I've tried a few different ways of doing the syntax. Is there a simple way to do this by just sticking something in the filter field when you click on the ... button for the order code combobox? Or do I have to write some Python? I have looked through the archives and Jesus seems to have posted something similar to what I'm trying to do and he has written python. Many thanks, Rob ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Hk-classes-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
