Alekhan 0 Light Poster

Hello All,
I am currently working on Accounting Software, I am using treeview and access database table with name of ChartofAcc, the data sample is like:

AccNo AccName Header AccType Opn/Balance
10000 Asset yes Asset 100000$
11000 FixedAsset No Asset 50000$
11100 Motor Vehicle at Cost No Other Asset 25000$

Method I am using is, If else conditions to view treeview as follow
1-0000 Assets Asset 100000
1-1000 Fixed Assets Asset 50000
1-1100 Motor Vehicleatcost Asset 25000

but It took a long coding and somemore if there is change in accounts chart it will disturb the whole settings. So I want help regarding automating code, and if we add new record under any heading it should display somthing like i mentioned above.

Plz help me in this regard.
Thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.