Thanks again Razzak. I have looked at the online DBTreeView Corporat.RB1 example. That example shows DBTreeView showing Departments and a Scrolling Region for Staff. The link between the two tables is the column DepartmentID.
Then with Dennis' tip that I can capture the Column(s) of the row selected... and your comment about using a "dummy one row table"... My gears are moving again! Regards Lena -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, July 06, 2011 1:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB TreeView At 01:51 PM 7/6/2011, Lena Dammstrom wrote: >Thank you Razzak, that is what I thought. > >However, if I have a table Employees >EmpNumber (IdField) EmpDept (ParentField) EmpName (text) >1 1 Lena1 >2 1 Lena2 >3 2 Someone1 >4 2 Someone2 > >Then using DB TreeView I select EmpNumber 3 Someone1. >I want to update a different table with what was selected in >the DB TreeView... 3 Someone1. >Is there a property that I can store in a variable/and or >update my other table with? Very interesting concept, Lena! Without knowing further details and the table structure, let me put together a swift sample application for you. This will illustrate as well as demonstrate the typical use of DB Tree View control in R:BASE 7.6, Turbo V-8, and R:BASE eXtreme 9.1. Please stay tuned ... Very Best R:egards, Razzak.

