can this be done?

I have in mind being able to write something like:

create table 'mytable' with fields 'Mydate':D, 'MyRef':C:15,'MyNum':N:10.2 indexed on MyDate, MyNum

we cant use Sql because in the kind of context I am thinking of, the field name might often be extracted from the data - for instance Sales Reps names...

eg

create table 'mytable' with fields 'Commission':N:10.2, Rep1:C:20,Rep2:C:20,Rep3:C:20 etc...

or, for example creating edi forms to suit a supplier using template details provided by them but stored in your data...

eg

create table 'mytable' with fields theirfield1:theirtype1,theirfield2:theirtype2, theirfield3,theirtype3 etc

did I see a thread somewhen on this?

or did I dream it?

Harry