Duplicate Documents / Field - Doc Numbers

jham6495 · Sep 20, 2005

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?

Thanks,
Jay

pmonett · Sep 21, 2005

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.

Pascal.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Duplicate Documents / Field - Doc Numbers

jham6495

Technical User

pmonett

Programmer

Similar threads

Part and Inventory Search

Sponsor