<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Base Index Design not saved" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138091#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Base Index Design not saved" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138091">bug 138091</a> from <a class="email" href="mailto:FKlusmann@aol.com" title="Fred <FKlusmann@aol.com>"> Fred</a> <pre>(In reply to Robert Großkopf from <a href="show_bug.cgi?id=138091#c1">comment #1</a>) Thank you. Please refer to BH40-BaseHandbook, page 41. A test table (People) would have Person_ID (primary key, autovalue), FirstName, Initial, LastName (all Text [VARCHAR]). It is possible that there are several "John Q Public". Each would have his own Primary Key (PK). I want to create an Index of the (3) name fields. Edit the Table, <Tools><Index Design> and see several ~SYS_IDX_##~ Click the leftmost icon (New Index) and see ~index1~ Select each of the name fields, then click "Close" Verify that Unique is checked. See the "Do you want to save the changes made to the current index?" Click "Yes" Read "Index not found: index1 in statement [DROP INDEX "index1" ON "People"] Note: the names shown for the indexes are not constant.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>