Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Table db Design > Creating non-PK...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 12017 of 12659
Post > Topic >>

Creating non-PK unique constraints in Access 2003

by dave.j.thornton@[EMAIL PROTECTED] Jul 20, 2008 at 09:45 AM

I need my PK to be a single field so that I can establish parent-child
relation****ps. Therefore I create an autonum field at the top of my
table, and designate that as my PK.

I also need a composite uniqueness constraint on two of the real
fields in the table. I can't seem to find a good step-by-step for
making this non-PK constraint. I can get to the indexes dialog box,
but I've tried a couple things, and none of them seem to resuly in a
constraint. Can someone walk me through it?
 




 2 Posts in Topic:
Creating non-PK unique constraints in Access 2003
dave.j.thornton@[EMAIL PR  2008-07-20 09:45:47 
Re: Creating non-PK unique constraints in Access 2003
"Allen Browne"   2008-07-21 00:58:44 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 22:32:23 CST 2008.