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]> 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 > <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]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/03CA3D8E-8286-4A9A-AD31-C6C071EE369D%40albertberry.com.
