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
