Hi. I have an application. I want to create some user defined fields for a number of tables. The idea is that I have a setup table (udf Structure) where the user can choose the form and insert records which contain properties for new fields. The properties are tablename, Caption (ie. 'Architect'), Type (Character,Numeric,Logical), Size, InputMask, Format, etc. I want to modify the table structure of a udf Local table (ie. udfJob, udfInventory) and automatically build the fields onto the appropriate screen.

I figured that the table containing the udf Structure can be a regular table within the DBC, but I'm not sure what to do with the tables (udfJob) that will contain the client's data (with the fields - ie. Architect C(20)). I don't want SDT to automatically overwrite the structure when I send a new updated DBC and meta tables (my app uses Visual Extend - so it updates all the structures when the app changes and there is a new DBC and other files in an Update directory.)

The problem is that SDT does not have separate properties for Update and Re-Index and while I don't want the Update to happen, I may want to re-index their tables from time to time to allow for deleted records. I want to build a relationship between the primary table (Jobs) and the other table udfJob based on the primary key so I can bring these records in as required.

Does anyone have any suggestions to allow me to have user defined fields whose number and structures change from client to client?

Thanks for the suggestions!

Sandi Cassidy