PDA

View Full Version : Access Database


aveary
Oct 9, 2013, 04:01 PM
Is there a way to flag information in an access database so that the same data cannot be input twice? I work with a vehicle control system but some of the vins are showing up more than once. I think more than one person in the office may have entered the same paperwork or two people registered the same vehicle causing it to show up twice... trying to prevent this from happening again.

Thanks

ScottGem
Oct 9, 2013, 04:26 PM
Sure, In table design mode select the VIN field and set it to No duplicates.

aveary
Oct 9, 2013, 04:48 PM
Awesome! Thanks so much.