Solved

Preventing duplicate entries

Posted on 2011-09-08
4
181 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
  • 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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…

911 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now