List box selection

[#1]

Hi,

I want to restrict the user to not to select more than one value in the list box. But i dont want to use the always one selected value .

[shree909]

hi,

go  to the listbox and select one value, then goto the properties of the listbox and from general select one value

that\ works fine

[#3]

Thanks for your response,but as i mentioned i dont want to use always one selected value since i want to clear it when navigating from one tab to another

[shree909]

when u navigfate from from one tab to another , whatever u have  in the current tab must be cleared.

this can be achieved by using bookmark.

the problem would be when u come back to the previous tab all your data will be cleared.

is that  what something ur looking. then use the bookmark .

[whiteline]

First I thoght about Triggers, macros an so on...

But then I think I'v found a better and more stable solution:

Create a separate table with a new feild that contains exactly the same values.Now we have two fields. Let's name them 'NewField' and 'FieldToClear' correspondingly.

Then create list box with 'NewField' and check it to 'only one' selection. Since this field is not connected with others it will not affect your model.

Then you can use set analiysis in your expressions, for example:

Sum({$<FieldToClear=P(NewField)>} amount) - in expressions

=aggr(Only({$<FieldToClear=P(NewField)>} FieldToClear), FieldToClear) - as dimension instead of FieldToClear

Of course you should hide the field FieldToClear from user.