[RBG7-L] - Re: property RBASE_FORM rebuild 'true'

[David M. Blocker]

Karen   You could set this up like Razzak's search forms:   1. User inputs partial entry in a variable edit field 2. Variable lookup list box is populated based on starting letters 3. User selects one from the list and that popuplates the Customer table below!   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: [EMAIL PROTECTED] To: RBG7-L Mailing List Sent: Monday, November 29, 2004 7:18 PM Subject: [RBG7-L] - Re: property RBASE_FORM rebuild 'true' Armin: I did something similar.  I created a 2-table form.  The first table is actually a single-table view of my customer table that concatenates the first/lastnames and has the CustID.  The second table is the customer table. The first table (view) has a list box in last name order.  The second table has all the DBEdit fields.  You click on a name in the view's list box and you get the edit fields all filled in.  The only problem is that there's no "searching" -- you have to navigate to the customer in that list box. Karen Hi all    (Have a look to Doug Hamilton's mail from 11/3/04, too) I know the upper PROPERTY-Command doesn't exist. But it would be nice if ... Reason: I have one form with a      --> Variable Lookup ListBox (in order to choose the CustId --> vCustId)  and some --> DbEdit - Fields (in order to edit CustName... that belong to the CustId). I'm looking for a possibility to choose the CustId out of the  ListBox and directly (without any other form)  edit the record that belongs to that chosen CustId. I don't want to use a CHOOSE-Command before, I dont want to use temp. table. Solution (not the best one, but it works) --Call the Form SET VAR vCustId INTEGER = 1  (first record is to see) WHILE vCustId > -1 THEN  EDIT USI FCustEdit WHE CustId = .vCustId ENDWHILE RETURN --OnClick-EEP in VarListBox CLOSEWINDOW RETURN -- BitButton to CLose the form SET VAR vCustId = -1 CLOSEWINDOW RETURN -- BitButton to add a new row property table Customers 'append' saverow property CustIdList refreshlist 'true' RETURN Well, it works, but I'm looking for an elegant solution. With an property-command like                   property RBase_Form rebuild 'true' one could reach that goal elegant. Regards Armin