Re: how can i get multiple primary keys
romona26 wrote:
I am trying to put three or four primary keys in my policies table
but i dont know how to do it cab someone help me?
A table can have exactly one Primary Key.
If what you meant to say is that you want your one PK to consist of multiple
fields then hold shift or control so you can select multiple fields before
pressing the "key" in the toolbar.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
Relevant Pages
- RE: creating a new database
... if i dont link them to the courses and costs, how would we need what have ... ---CourseID Autonumber Primary Key ...
(microsoft.public.access.modulesdaovba) - Multiple field primary key and other indexes
... I have a database that has multiple fields for it's primary. ... Since any of these 3 fields are used for sorting, ... These three fields are are defined as the primary key. ...
(microsoft.public.access.tablesdbdesign) - RE: CANT see EDIT UPDATE CANCEL Buttons for DATAGRID
... For updating the SQL database using data grid, is primary key required? ... dont have a primary key in the SQl table. ... >> records are displayed where company name matches with user input. ...
(microsoft.public.dotnet.framework.aspnet) - Re: setting a multi-field key index
... Highlight multiple fields. ... If you are looking to set a multi-field index that is NOT a primary key, ... open the index window and add multiple fields to a single index. ... Microsoft IT Academy Program Mentor ...
(microsoft.public.access.gettingstarted) - Re: Coding at table with multiple primary key columns
... Hey Andi, this solution does not work I am getting a Constraint error. ... I dont know if that makes a difference. ... the unique contraint do the same thing as the primary key. ...
(microsoft.public.access.modulesdaovba) |
|
