Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Access Database (https://www.askmehelpdesk.com/showthread.php?t=770653)

  • Oct 9, 2013, 04:01 PM
    aveary
    Access Database
    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
  • Oct 9, 2013, 04:26 PM
    ScottGem
    Sure, In table design mode select the VIN field and set it to No duplicates.
  • Oct 9, 2013, 04:48 PM
    aveary
    Awesome! Thanks so much.

  • All times are GMT -7. The time now is 01:04 PM.