Hi All,

We´re designing a new software and we want it to be customizable without code. That, for us, mean we can change the software behaviour without re-writing code. All will be developed using C and .NET.

One of our goals is to have what we are calling "dynamic tables". This means that these database tables may have different fields depending on the customization. We got to know it using high-level ERPs like SAP or CRM´s system like VTIGER or even SalesForce. Let me give an example:

CUSTOMER TABLE:

FIELDS: ID, NAME, ADDRESS, PHONE.

This would be the standard Customer Table.

Now, a new customer needs to add FINANCE SCORE and RANKING to the database. We them would like to go to our application (not the database itself) and adding these new fields. After that, all of my input forms and reports would start to show and process these new fields.

We haven´t found the best way or methodology to architect and develop that, so I very much appreciate any kind of help regarding this theme.

Thanks in advance for any help.

Rds

Renato