98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » PRIMARY KEYS
PRIMARY KEYS
Resolved · Urgent Priority · Version 2007
George has attended:
Access Intermediate course
Access Intermediate course
PRIMARY KEYS
WHEN WOULD YOU USE MULTIPLE PRIMARY KEYS AND GIVE EXAMPLES
RE: PRIMARY KEYS
Hi George
Thank you for your question
Multiple or compound keys are used in place of an autonumber field, where there is no one existing field that is unique to individual records.
For example if you had a staff database with no unique fields you might decide to use a key compounded out of first name, second name and date of birth fields
The important consideration would be the uniquness of each combination. In the above example the developer would have to consider the likelihood of two people sharing the same first and second names as well as a date of birth
Hope this helps
Regards
Stephen
Thu 5 Mar 2009: 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:Change The Default Font in Access 2003You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set. |