Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Duplicate Documents / Field - Doc Numbers

Duplicate Documents / Field - Doc Numbers

Duplicate Documents / Field - Doc Numbers

I am trying to figure out how to adjust a field to not allow duplicate values to be saved.  I have a complete document database and during an audit found that we had a duplicate document with the same document number and name, but the content was different. In Access there is a no duplicates selection, is there a way to perform this function in Lotus Nots?


RE: Duplicate Documents / Field - Doc Numbers

A duplicate in Notes is not the same notion as in relational RDBMSs. The only duplicate possible in Notes is of the same document, and that is flagged as a Replication/Save conflict.
So, to answer your question ; yes, there is a way to check for duplicate values in fields, but you have to program it by yourself - there's no easy function to call on.
That said, it's hardly difficult to implement. Just make a hidden view that selects all docs of the same type than the one you're working on. The first column should be the field you wish to check on, sorted and categorized. Then all you need is a Translation Formula in the field that gathers the existing field values using a @DBColumn, and that compares said values to the existing one. If you have a match, you have a duplicate and you need to alert the user.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close