>How can I index on multiple feilds of a table?
>
>Feilds A and B in table Mytable, I want combination of A&B unique. Like A B
> 1 1
> 1 2
> 1 3
> 2 1
> 2 2
>If I index them individually it doesn't allow me to add more than one combination.
>
If they're numeric fields, convert them to strings to concatenante the keys together. For example, if A and B are numeric fields, and you want to create an index on their concatenation:
INDEX ON
STR(A) +
STR(B) TO TEMP