I was thinking of that but I want to keep the users from picking inactive dealers. If they do not see it then they cannot select it.
Dan From: Bernard Lis Sent: Wednesday, July 11, 2012 9:43 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: db lookup combo box issue Why not just display all dealers and also display an X if inactive (blank if active). ----- Original Message ----- From: Dan Goldberg To: RBASE-L Mailing List Sent: Wednesday, July 11, 2012 12:12 PM Subject: [RBASE-L] - db lookup combo box issue I have an order form with db lookup combo box that has a where clause to bring up active dealers. The lookup works fine except for one thing. When I am viewing an existing order with an inactive dealer, the displayed dealer name in the combo box is blank because they are inactive. I can put a box above it with the dealer name but that sort defeats the purpose of the db lookup combo box. Has anybody found a workaround for this issue? TIA Dan Goldberg
