* Create structural indexes USE mytable EXCLUSIVE INDEX ON field1 TAG field1 INDEX ON field2 TAG field2 ... INDEX ON field1+field2 TAG f12 ... USE * Open table with order set * may be slower than opening a table and setting order afterwards USE mytable ORDER TAG f12 ... * Set order to another tag SET ORDER TO TAG field1 ... * Set order using tag name stored in a variable - Name expression lcTagName = "field2" SET ORDER TO TAG (lcTagName)>I am Newbie to Fox, I am teaching myself this, I am using DB with FPDOS26 and when it comes to Index, I go like SET INDEX TO varNAme but I get an error saying DB not INDEXED! what I am doing wrong friends?