98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
Access
Resolved · Low Priority · Version 2003
Mon 31 Jan 2011, 15:49Delegate Ben said...
Ben has attended:
Excel Intermediate course
Access Introduction course
Access
What happens if I don't my primary key contains non-unique entries?
Tue 1 Feb 2011, 14:04Trainer Anthony said...
RE: Access
Hi Ben, thanks for your query. By definition a primary key field has to comprise unique identifiers. If it doesn't, when you run a query to return a specific record you will get two conflicting results which is definitely not what you want. If in doubt, just set an ID field to the Autonumber datatype if you need a new primary key field.
Hope this helps,
Anthony
Tue 8 Feb 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Hide Access TablesOne method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys. |
