reading / updating array of arrays object in javascript / jquery
<p>I am trying to do the following but I am not sure how to do it. I have a grid (like excel) where the user will enter information. The grid has columns like "empno", "paycode", "payrate", "hours" etc. The user will enter a separate record in the grid for each paycode for each employee in the system. so the grid will look like the following</p>

<blockquote>
<pre><code>empno    paycode      payrate          hours
1        R            25.00            40.00
2        R            12.00            40.00
3        R            15.00            18.00
1        v            25.00            12.00
2        PTO          25.00            18.00
</code></pre>
</blockquote>

<p>Below this grid I will have two grids. One that displays "Employee totals" and one that displays "Totals by paycode". so as the user enters the data in the grid, I am planning to add / update the values into a two dimensional array. Then when the user clicks on a particular record on the grid, I will read the empno from that record and display the employee totals by binding the array to the html table. As you can see the data entered by the user might not be in the order of empno. The user might first enter the data for paycode "R", then paycode "V" etc.</p>

<p>Please let me know your ideas.</p>
