I'm guessing the biggest advantage to 3 is that option 2 has an extra index that is being maintained for no reason. The one on lineID by itself might never be used.
Thanks again for the reply.
>I think so. But I think using invoice no. in primary key, since it will be part of the primary method of selecting recs also helps.
>
>
Steve Gibson