Apr 20, 2005 #1 reta Technical User Dec 23, 2004 51 AU Hi Is there a way of creating TWO primary keys in a table in access 2000. Thanks Reta
Apr 20, 2005 1 #2 PHV MIS Nov 8, 2002 53,708 FR NO, but you may create many UNIQUE index. But perhaps you want a PK on 2 fields ? To do this, in the table design view select the 2 fields and click the PK toolbar button. Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244 Upvote 0 Downvote
NO, but you may create many UNIQUE index. But perhaps you want a PK on 2 fields ? To do this, in the table design view select the 2 fields and click the PK toolbar button. Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244