Hi Harry ---
Maybe this will help........
x="lastname"
y="firstname"
CREATE TABLE names (&x C(20), &y C(20))
>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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05