<div>
You could create a composite index of the two fields, making them unique. &nbsp;This would prevent the combo of the two from being added to the db.<br />

</div>


You could create a composite index of the two fields, making them unique.  This would prevent the combo of the two from being added to the db.


<div>
Thanks<br />
Can you please say how I create a composite field in access please?
</div>


Thanks
Can you please say how I create a composite field in access please?

<div>
Many thanks for the answers.<br />
<br />
Very helpful<br />
Regards<br />
John
</div>


Many thanks for the answers.

Very helpful
Regards
John

<div>
<div class="content wysiwyg-content">
Hello<br />
I have an access.mdb table with three fields<br />
ID Key autonum<br />
supplierID number<br />
StockID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; number &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
I want to combine supplierID and StockID in one and make it unique <br />
Is this possible in access.mdb?<br />
Regards<br />
John
</div>
</div>


Hello
I have an access.mdb table with three fields
ID Key autonum
supplierID number
StockID	    number	
I want to combine supplierID and StockID in one and make it unique 
Is this possible in access.mdb?
Regards
John

access.mdb unique field

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.