>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.
>
>
>Thanks in advance
>Gnana.
Gnana,
you can use something like STR(A,10)+STR(B,10) in index expression if fields A and B are numeric.
Regards
Alex