Jump to content

Validating Field to Avoid Duplicate Record


bugsy
 Share

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

Recommended Posts

  • Newbies

Hi,

How can I validate a field to avoid duplicates. i.e. CompanyID 1 = ABC Company

CompanyID 2 = XYZ Company

And if ABC Company is entered again, it will link to CompanyID 1, etc.

Many thanks for your help,

Andre

Link to comment
Share on other sites

erm 1st off i'd make companyID an auto generated number, to do the work for u (key field, so u can change the name later etc.)

then make companyName and validate it to be unique.

so Company ABC cannot be entered twice.

however Company ABC and Company ABC (double space, are 2 diff things so it wont stop this.)

in my DB i made the company name field on data entry a drop down, auto complete so if i type 'Company' and 'Company ABC' appears below i can see some1 else has entered it and abort my creation.

Link to comment
Share on other sites

  • Newbies

Thanks. The extra space is just a typo.

But to be more explicit, once I created the company name (ABC Company), I have to add the contact name, etc.

Then I need to create another record for another contact name with the same company (ABC Company). If I used the unique value and serial number, then it will prompt me for duplicate. What I want to happen is to create another record (new contact name) but using existing Company ID and Company Name.

Thanks.

Link to comment
Share on other sites

You would want to have a related table for your contacts. Each contact in the table would have an associated companyID which represents each different company.

Link to comment
Share on other sites

This topic is 5696 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.