**
Hi :)

I just tried to create a unique index in 8.1 and I failed to do so in some cases.

On a custom form I can create unique (or not unique) indexes simply using the list which is in "unique index" column in the form "Definitions" tab, "Indexes" part.

Though if I want to do so on a "base" form (let's say "HPD:Help Desk") I can't.
I overlay the form.
I go to "Definitions" tab, the "Indexes" part, I choose overlay type "additive" and I can click on "new" to create a new index, I can choose fields, works ok, BUT I can't choose if the index is unique or not, it seems it's set to "No" and you don't have the "list" to choose "yes".

As a test I created a simple regular form and tried to define an index, I could see the "list" in "Unique" column so I can choose "yes" or "no" (03.png):
03.png

I don't actually create the index and I converted my custom form to "base" and I tried to create the same index on the overlay, so:
-> I overlay the form.
-> I go to "Definitions" tab, the "Indexes" part, I choose overlay type "additive" and I can click on "new" to create a new index and this time no way to get the list so I can't select "yes" (04.png):
04.png


The workaround I found is to:
-> I overlay the form.
-> I go to "Definitions" tab, the "Indexes" part, I choose overlay type "additive",
-> I save the form,
-> I switch to "base development",
-> I open the form,
-> I go to "Definitions" tab, the "Indexes" part, I add the index there (I can choose "yes" or "no" there) ,
-> I save the form,
-> I switch back to "best practice" mode,
-> I open the overlay form,
-> I can see my index,
 

Do you have the same behavior?



Best regards.


Laurent.
_ARSlist: "Where the Answers Are" and have been for 20 years_

Reply via email to