Hi,

I have a field 'lote' containing unique values like

TM07082004
TT07082004
TN07082004
TM08082004
TT08082004

I'd like to know whether I should use this field as primary key for my table, or create an autonumeric field and use that instead.

What are the drawbacks/advantages of each approach ?

Thanks a lot.