Well one thing you can do is change the access to the form. In my opinion there is no reason to 'edit' an order from an inactive customer but you would want to 'browse' or look at it.
Then use PROPERTY commands to hide or show different information. -----Original Message----- From: "Dan Goldberg" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 11 Jul 2012 10:03:25 -0700 Subject: [RBASE-L] - Re: db lookup combo box issue 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
