By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,805 Members | 1,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,805 IT Pros & Developers. It's quick & easy.

avoiding duplications of records

P: n/a
CTG

I have an access table
The fields are
F1 AutoNumber
F2 text 20 chars long
F3,...F7 cobination of Text, Yes/No and DTime.

How do I go about making sure F2 is going to be unique for every
record in the table and avoid having dupliactions in the table?

Do I have to re-def the PK to be F2 ? ..It is long and I am trying to
not creates large indices.
Thanks

Sep 13 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.