>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.

if A and B are integer fiuelds You can use smething like:

padl(5, 10, '0')

dependig on how big your integer number will be increased.

Regards
Oscar