Multiple Index Key in Access2000

[eimroda]

I have two fields (StudId and DatePaid) together with other fields in my table. I could not make my StudId to be my only key (to avoid duplicates due to some circumstances. What I wnt is to assign StudId+DatePaid to be my Key. How can I do it? (in access or in vb ado).

[MRostron]

in table design create an index on the first field allowing for duplicates then open the index window and add the second field to the list. The comdination of the two fields should now create you a primary key..

Max