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

Duplication Prevention

P: 4
I am a novice when it comes to access.

I was wondering if there is a function that would prevent an end user from entering a duplication value in a field.

For example I have a job name: XYZ that has a work order #: 123456. The job name can have many work order #'s, (1:M, relationship) but that work order number is only unique to that job name.

How can I prevent the end user from entering in work order #'s that go to different job names.


Thanks
Mar 19 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I am a novice when it comes to access.

I was wondering if there is a function that would prevent an end user from entering a duplication value in a field.

For example I have a job name: XYZ that has a work order #: 123456. The job name can have many work order #'s, (1:M, relationship) but that work order number is only unique to that job name.

How can I prevent the end user from entering in work order #'s that go to different job names.


Thanks
If a work order # cannot be used for two different jobs and will be unique to the table then in the table design set the indexed property of this field to Yes (No Duplicates)

Mary
Mar 22 '07 #2

P: 4
thanks! It works great!
Mar 22 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
thanks! It works great!
You're welcome.
Mar 23 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.