>Whenever I find a PO number at a different site I get the error message
>
>Uniqueness of index CRELPONO is violated.
>
>where "CRELPONO" is the index associated with the PO number.
>
>The table is buffered and the index is a "candidate" index because the user needs unique PO numbers
>
>I have tried to fix it unsuccessfully.. How do I fix the problem so that I do not get the error message (number 1884)?
A SWAG, but perhaps do you have a row in the table with a blank or empty PO number? Maybe one that has been deleted? If the latter, you could try PACKing the table.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up