Help required in data hierarchy

[#1]

I have only 2 columns.i need data hierarchy. Pl Help

Short_Desc	Material_Name
Aerobid	(DISC)AEROBID-M PLACEBO DISPLAY EACH
Aerobid	AEROBID-M SAMPLE(1 CAN X 7GM)  7GM  DISC
Aerobid	DISC AERO BRONCTREE MODEL      EACH
Aerobid	DISC AEROBID-M INHALER SYSTEM     7GM
Aerobid	DISC AEROBID-M PA SAMPLE (1 CAN x 3.5GM)
Aerobid	DISC AEROBID-M SAMPLE(1 CAN X 3.5 GM)
Aerobid	DISC AEROBID-PA SAMPLE (1 CAN x 3.5GM)
Aerobid	DISC AEROBID INHALER SYSTEM     7GM
Aerobid	DISC AEROBID SAMPLE (1 CAN X 3.5 GM)
Aerobid	DISC AEROBID SAMPLE(1 CAN X 7GM)    7 GM
Aerobid	DISC AEROCH. DEMO CTR W/MOUTHPCE BX 20
Aerobid	DO NOT USE * AEROBID-M PLACEBO -> 2489
Aerobid	DO NOT USE * AEROBID PLACEBO CAN&HOLDER
Benicar	DISC Benicar 20/12.5mgHCT Sampl 7-bottle
Benicar	DISC Benicar 20mg Sample (10307) 1X7
Benicar	DISC Benicar 20mg Sample 7ct bottle each
Benicar	DISC Benicar 20mg/12.5mg HCT 30ct EEP ea
Benicar	DISC Benicar 40/12.5mgHCT Smpl 7-btl eac
Benicar	DISC Benicar 40/25mgHCT Sample 7ct bottl
Benicar	DISC Benicar 40mg Sample (#10407) 1X 7
Benicar	DISC Benicar 40mg Sample 7ct bottle each
Benicar	DISC Benicar 40mg/12.5mg HCT 30ct EEP ea
Benicar	DISC Benicar JNC7 Goal Program
Celexa	CELEXA                              1 OZ
Celexa	CELEXA 20MG                           90
Celexa	CELEXA 20MG                          500
Celexa	CELEXA 20MG                         1000
Celexa	CELEXA 20MG                         5000
Celexa	CELEXA 40MG                           90
Celexa	CELEXA 40MG                          500
Celexa	CELEXA 40MG                         1000
Celexa	CELEXA 40MG                         5000
Celexa	CELEXA BULK 10MG TABLETS TRADE
Celexa	CELEXA BULK 10MG TABLETS Validation
Celexa	CELEXA BULK 20MG TABLETS TRADE
Celexa	CELEXA BULK 40MG TABLETS TRADE
Celexa	CELEXA TABLETS 10MG     100
Celexa	CELEXA TABLETS 20MG     100
Celexa	CELEXA TABLETS 20MG(CHALLENGE) 30  DISC
Celexa	CELEXA TABLETS 40MG     100
Celexa	CITALOPRAM HBR
Celexa	DISC CELEXA-PA 20MG Sample 1X7    1 each
Celexa	DISC CELEXA-PA 20mg STRTR KIT 1x14 1cd
Celexa	DISC Celexa-PA Tablets 40mg     100
Celexa	DISC CELEXA     4 OZ
Celexa	DISC CELEXA  Liquid     8 OZ
Celexa	DISC CELEXA 20MG      30
Celexa	DISC CELEXA 20MG H.U.D.            10X10
Celexa	DISC CELEXA 20MG SAMPL(1X7 W/O GRAV)1CRD
Celexa	DISC CELEXA 20MG SAMPLE (1x7 TAB) 1 CARD
Celexa	DISC CELEXA 20MG STRTR KIT(1x14TAB)1CARD
Celexa	DISC CELEXA 20MG TABLET SAMPLES  BULK

[montero91]

Hi Kirti,

Create a new field Short_Desc & '/' & Material_Name as TreeView.
With the new field inserts a list, in the General tab  enable show as TreeView whit  Separator '/'.

I hope you serve or you can give an example of what you seek.

[#3]

I have tried that as well but by doing this i am not able to select Short _Desc.. I have to select respective material_Name only.

What i am looking for is when i click on Short_Desc, all correponding Material_Name should get selected.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#5]

Awesome..!! Thnx..