Table Grid editing with normalized data

rcheung

If I have a table like this I can edit it in a grid format.

Project
-----------------
ID          int
Title       varchar(100)
EstimateA   varchar(100)
EstimateB   varchar(100)
EstimateC   varchar(100)

Is it possible for me to make a table with a join like this but have dynamic Estimate Columns and still use the grid update?

Project
-----------------
ID          int
Title       varchar(100)

Estimate
-----------------
ID          int
ProjectID   int
Estimate    varchar(100)

allan

Yes it is possible, but its a good bit more tricky. You'd need to make an Ajax call to get the information about how many columns there are for that table, and then dynamically build the columns object based on that information. On the Editor side of things you would need to use a left join and make sure that you submit the estimate table's id column as a hidden field.

Allan