Solved

Preventing duplicate entries

Posted on 2011-09-08
4
211 Views
Last Modified: 2012-05-12
I have a database that I enter refunds checks in, the problem I am having is preventing duplications.

I have two vendors with the same check number, so I can’t make the check number unique.  

I can’t used the vendors’ name because the vendor’s name is used repeatedly used because of multiple checks received.  

Can anyone advise on how I can resolve this issue?
0
Comment
Question by:Delores_C
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 36504242
You have to use both fields.
In your table design create a unique  index based on both fields.
In the index dialog select the name and in the next line select the the check number.
Then assign a name to the index name (e.g. NameNumber) against the Name field and set it to Unique = Yes.
0
 

Author Comment

by:Delores_C
ID: 36504322
Can you explain a little more?  Not quite understanding
0
 
LVL 77

Accepted Solution

by:
peter57r earned 125 total points
ID: 36504548
Look at the attached example  - you have the table open in design view and choose Indexes from your menu or ribbon.
Then specify both fields in the centre column and give the composite index a name in the left column.
Set the Unique option to Yes as shown.
index.JPG
0
 

Author Closing Comment

by:Delores_C
ID: 36504892
works great!  Thanks alot
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question