on 2009-03-31 04:27
on 2009-04-04 16:07
Lee, You could also create two tables, one which describes a particular projects column use and another which stores the actual data columns. The first metadata table would have one row per project and the data in the second would identify which project they are associated with. This way you just create a new row for a new project and never change the table structures. The validations can be driven by the metadata table specifications. Brendon.