Cascading ComboBoxes with unique values and sum

[guilmerj]

Hi all,

I have something like the table below and I need to fill 4 comboboxes and 2 TextBoxes with these values:
Combo1 = Directors level 1
Combo2 = Directors level 2
Combo3 = Company
Combo4 = CostCenter
TextBox1 = HeadCount JAN 2014
TextBox2 = HeadCount DEC 2014

For each Combobox I choose I need the following comboboxes and textboxes to be automatically filled based on what I chose...For Example:
Combo1 = Director 02
Combo2 = Director P, Director I
Combo3 = Company E, Company f
Combo4 = 1006, 1007
TextBox1 = 83 <- sum of JAN
TextBox2 = X <- sum of DEC

It´s a little bit difficult because there is a lot of data in each collumn.

[TABLE="width: 693, align: center"]
<tbody>[TR]
[TD]Level 1[/TD]
[TD]Level 2[/TD]
[TD]Company[/TD]
[TD]CostCenter[/TD]
[TD]JAN 2014[/TD]
[TD]DEC 2014[/TD]
[/TR]
[TR]
[TD]Director 01[/TD]
[TD]Director G[/TD]
[TD]Company A[/TD]
[TD]1006[/TD]
[TD]59[/TD]
[TD]52[/TD]
[/TR]
[TR]
[TD]Director 01[/TD]
[TD]Director G[/TD]
[TD]Company B[/TD]
[TD]1013[/TD]
[TD]38[/TD]
[TD]55[/TD]
[/TR]
[TR]
[TD]Director 01[/TD]
[TD]Director G[/TD]
[TD]Company C[/TD]
[TD]1016[/TD]
[TD]33[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]Director 01[/TD]
[TD]Director H[/TD]
[TD]Company D[/TD]
[TD]1017[/TD]
[TD]56[/TD]
[TD].[/TD]
[/TR]
[TR]
[TD]Director 01[/TD]
[TD]Director H[/TD]
[TD]Company A[/TD]
[TD]1016[/TD]
[TD]70[/TD]
[TD].[/TD]
[/TR]
[TR]
[TD]Director 01[/TD]
[TD]Director H[/TD]
[TD]Company A[/TD]
[TD]1005[/TD]
[TD]11[/TD]
[TD].[/TD]
[/TR]
[TR]
[TD]Director 01[/TD]
[TD]Director O[/TD]
[TD]Company A[/TD]
[TD]1019[/TD]
[TD]66[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director 02[/TD]
[TD]Director P[/TD]
[TD]Company E[/TD]
[TD]1006[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director 02[/TD]
[TD]Director I[/TD]
[TD]Company F[/TD]
[TD]1007[/TD]
[TD]66[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director 03[/TD]
[TD]Director J[/TD]
[TD]Company A[/TD]
[TD]1013[/TD]
[TD]81[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director 03[/TD]
[TD]Director J[/TD]
[TD]Company C[/TD]
[TD]1003[/TD]
[TD]42[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director 03[/TD]
[TD]Director K[/TD]
[TD]Company A[/TD]
[TD]1013[/TD]
[TD]63[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director 03[/TD]
[TD]Director K[/TD]
[TD]Company D[/TD]
[TD]1010[/TD]
[TD]62[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director 03[/TD]
[TD]Director L[/TD]
[TD]Company F[/TD]
[TD]1001[/TD]
[TD]68[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director 04[/TD]
[TD]Director M[/TD]
[TD]Company B[/TD]
[TD]1003[/TD]
[TD]89[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director 04[/TD]
[TD]Director N[/TD]
[TD]Company J[/TD]
[TD]1007[/TD]
[TD]37[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Director 04[/TD]
[TD]Director N[/TD]
[TD]Company A[/TD]
[TD]1007[/TD]
[TD]66[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks in advance!