Posted on 2008-11-10
I have two tables that are one-to-many with a third join table. I can put these in a cross-tab, with the two one-side tables as the row and column labels and the join table as the values. (Please see demo attached in related question for an example.) But since the values of the cross-tab have to be a summary function on the join table values (I used either "First" or "Max", I think), they are not editable.
If I wanted to present the data in a similar fashion, but have the values be editable, how would I do that?
In the related question, I took a look at the Spreadsheet control. If there are other (simpler) ways to do this, how to do so (detail preferred) would answer the question. Otherwise, details on the Spreadsheet control's usage for an application like this would suffice.