>>>I'm developing in VFP 3.0.
>>>
>>>When I issue the command:
>>>
>>>INDEX ON abc TAG xyz
>>>
>>>the resulting index is of type UNIQUE. I want this to be a REGULAR index, as the help text states it should be. Has anyone else run across this? Is there a way to create a regular index using the INDEX command? I have to build the index on the fly and not thru the table designer.
>>>
>>>Thanks in advance for any and all help.
>>>
>>>Regards,
>>>
>>>Rob
>>
>>It looks that you inadvertently SET UNIQUE ON before launching INDEX. SET UNIQUE OFF and delete this tag and then INDEX again.
>
>Thanks. You were right
Rob, check in Tools/Options/Data. One of the check-boxes sets Unique Records in Indexes. If this is set ON, your problem will re-occur whenever you load VFP. Set it off, then click the "Set as Default" button.
HTH