Duplication Prevention

[rpeeler]

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

[MMcCarthy]

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

[rpeeler]

thanks! It works great!

[MMcCarthy]

thanks! It works great!

You're welcome.