Thx that is what I have done in the past but was hoping there was a way to display it in the combo box.
Dan From: 'Karen Tellef' via RBASE-L <[email protected]> Sent: Thursday, September 12, 2019 6:37 AM To: [email protected] Subject: Re: [RBASE-L] - db combo lookup box not showing value I do exactly as Albert says. I would display the vendor name in a non-editable variable box, and then locate a little button to the right of it to select the active vendors. I sometimes put just a bmp of a little down arrow to duplicate the look of a combo box Karen -----Original Message----- From: Albert Berry <[email protected]> To: rbase-l <[email protected]> Sent: Wed, Sep 11, 2019 7:05 pm Subject: Re: [RBASE-L] - db combo lookup box not showing value Perhaps displaying the vendor in a text box and having a double click drop down EEP on the field that would only see the active vendors? Albert On Sep 11, 2019, at 4:05 PM, Dan Goldberg <[email protected]<mailto:[email protected]>> wrote: I have a part form with a db combo lookup box. I want to use the where clause to only select active vendors, which works fine. But if I want to look at a part that has an inactive vendor the field shows blank. How can I show the value but still only let the user see/select the actives? <image002.jpg> Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0011EB52B9D%40EXCHANGE10<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0011EB52B9D%40EXCHANGE10?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/03CA3D8E-8286-4A9A-AD31-C6C071EE369D%40albertberry.com<https://groups.google.com/d/msgid/rbase-l/03CA3D8E-8286-4A9A-AD31-C6C071EE369D%40albertberry.com?utm_medium=email&utm_source=footer> . -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/418222923.6419669.1568295438601%40mail.yahoo.com<https://groups.google.com/d/msgid/rbase-l/418222923.6419669.1568295438601%40mail.yahoo.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0011EB53C09%40EXCHANGE10.
