I'm developing a datagrid in AIR application that reads from a SQLite DB, I want to dynamically create datagrid with a matrix look, 3 tables to read from .
Table1 VALUES lists the rows
Table2 GOALS lists the Colums
Table3 GVContent is the matrix content data that mapps to the goals to values.
The goals and values will have a ID as primarykey
In the GVContent Table for each Value there will be a list of goals in the same row table structure looks like this Eg. (....ValueID,Goal1,Goal2,G
5) Max number of Goals is 7
Attached is an excel file to demo what it should look like, the challenge is to create it dynamically.