Access Validation Rule

  wiznyme 14:07 26 Feb 2003

I'm trying to set up a rule in an Access database that will check if a number has been entered in a previous record and if it has reject it.

I've set the number as the primary key and selected Indexed (yes no duplicates)but it's still allowing duplicates to be entered.

I'd be grateful for any suggestions you may have


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Indie publisher Canongate’s top 10 book covers of 2017

New iMac Pro release date, UK price & specs rumours

Tablettes Amazon Fire : quel modèle choisir ?