primary key question

[Tucker]

Hi all, within access, how do I go about making a coimbination of fields act
as a primary key? Thanks in advance, this has been driving me crazy today!

Tucker

 

[RoyVidar]

Hi all, within access, how do I go about making a coimbination of
fields act as a primary key? Thanks in advance, this has been driving
me crazy today!

Tucker

While holding ctrl, click the "field selectors" (the grey box to the
left of the field names) of the fields you wish to include in the
primary key. Then, either hit the primary key button on the toolbar or
right click to the right of the "field selectors" - for instance on
the field name of one of the selected fields, then select primary key
(for some curious reason, if you right click the field selectors, the
selction is lost)

 

[Guest]

To add some to Roy Vidar's answer, you can make a combination of fields *act*
as a primary key, without actually being set as a combined field primary key,
by using a multi-field index with unique values set to Yes.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________