Yeah...you got it figured out!  I am glad that you are enjoying it...we like it pretty good too

Of course you guys are way ahead of me. Don't know if it was there in 1.6 but in 1.61 editing a pk lets you turn the cluster off and a whole lot of other stuff.



Probably just missed it before.



LOVE the DDT !!!!

I see that my new best friend - the DDT - creates PK indexes as clustered.



Is there a good way to turn this off, either globally ( in source code ? ) or perhaps there is something I'm missing in the current interface ( writing this before installing 1.61 so if it's there already just point me to it )



I use a lot of UID PKs in tables I am converting from VFP and my understanding is a clustered index isn't a good idea.



TIA



Charles