Jump to content

Unique records


samantha
 Share

This topic is 7376 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Grr!

I have a unique identifier in my database (I defined it as unique by: 'define fields, options, validation, select unique tick box).

It works fine for data entry (i.e. say's I'm not allowed to duplicate id's in that field). But when I'm importing data, it'll allow my 'unique' field to have duplicate's in! Aargh! It took me hours yesterday to make sure that the right person had been allocated to the right company, as around 14 company's shared 'unique' id's!!

Consequently, I have no faith that the right people are married up to the correct organisation.

Does anyone know how to make the unique field option really work?!

thanks

A very frustrated Sam!

Link to comment
Share on other sites

This topic is 7376 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.