britboimike
10-24-2006, 02:02 PM
Hi
I am new to this and have a worksheet with data and want to create a form which shows columns from the worksheet. I want this in a treeview mode but cant seem to work it out.
In worksheet:-
Columns A, K and T ( yes, columns are split)
Family A Parent 1 Child 1
Family A Parent 1 Child 2
Family A Parent 1 Child 3
Family B Parent 2 Child 4
Family B Parent 3 Child 5
Family B Parent 3 Child 6
in Form:-
(z) Family A ----- (y) Parent 1 ------- (x) Child 1
|---- (x) Child 2
|---- (x) Child 3
(z) Family B ------ (y) Parent 2 ------- (x) Child 4
|---(y) Parent 3 ------- (x) Child 5
|----(x) Child 6
when i select (z) then this subsequently selects (y)s and (x)s... If select (Y)s then this selects (x)'s etc
then once selecting a submit button which fills in Column B in the worksheet with "PROCESSED"
is this possible? I really appreciate the help.
thanks
I am new to this and have a worksheet with data and want to create a form which shows columns from the worksheet. I want this in a treeview mode but cant seem to work it out.
In worksheet:-
Columns A, K and T ( yes, columns are split)
Family A Parent 1 Child 1
Family A Parent 1 Child 2
Family A Parent 1 Child 3
Family B Parent 2 Child 4
Family B Parent 3 Child 5
Family B Parent 3 Child 6
in Form:-
(z) Family A ----- (y) Parent 1 ------- (x) Child 1
|---- (x) Child 2
|---- (x) Child 3
(z) Family B ------ (y) Parent 2 ------- (x) Child 4
|---(y) Parent 3 ------- (x) Child 5
|----(x) Child 6
when i select (z) then this subsequently selects (y)s and (x)s... If select (Y)s then this selects (x)'s etc
then once selecting a submit button which fills in Column B in the worksheet with "PROCESSED"
is this possible? I really appreciate the help.
thanks