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 » microsoft access courses - Keys
microsoft access courses - Keys
Resolved · Low Priority · Version Standard
Jenny has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Keys
In a table can you combine two foreign key attributes to make a primary key without causes problems in the table. How do you do this
RE: Keys
You can make a primary key out of two fields.
Simply select BOTH fields in the design view and then click the Primary Key button.
This may or may not cause problems in your database, depending on how it is setup and layed out. Suggest backing up your database and testing it out first.
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:Modal formsIf you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On. |