How can I change a field property (index) automatically

[jeep2001]

I have a database app where weekly I need to import new data. I have 2 make table queries...is there a way to change a field attribute so that the field is indexed....
the index property set to true...THis way the queries that its involved in will be faster.

 

[PHV]

A starting point (SQL):
CREATE INDEX yourIndex ON yourTable (yourField );

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jeep2001]

OK thank you. I should have known that!