Hi,

I've got an ms access table with customers details. some customers ask to make a customer card for them and then they get a customer card no. so card_no is not a compulsory field. however, I'd like to make sure that this field can never have duplicate values.

any ideas how ?