<div>
You have to use both fields.<br />
In your table design create a unique &nbsp;index based on both fields.<br />
In the index dialog select the name and in the next line select the the check number.<br />
Then assign a name to the index name (e.g. NameNumber) against the Name field and set it to Unique = Yes.
</div>


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.

<div>
Can you explain a little more? &nbsp;Not quite understanding
</div>


Can you explain a little more?  Not quite understanding

index.JPG

<div>
works great! &nbsp;Thanks alot
</div>


<div>
<div class="content wysiwyg-content">
I have a database that I enter refunds checks in, the problem I am having is preventing duplications.<br />
<br />
I have two vendors with the same check number, so I can’t make the check number unique. &nbsp;<br />
<br />
I can’t used the vendors’ name because the vendor’s name is used repeatedly used because of multiple checks received. &nbsp;<br />
<br />
Can anyone advise on how I can resolve this issue? <br />

</div>
</div>


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? 


Preventing duplicate entries

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.