Multiple table selections Conditional

[#1]

Hi everybody,

  I have two multiple selection TIPO and UNIDAD

  When you select a TIPO, there are only two or three UNIDADEs you can choose. It depends of the TIPO.

What I need is that if you select more than one TIPO you only can choose between PESOS and EUROS in the UNIDADES Multiple Selection. How in the namy of Messi and the Pope can I do this?

Thanks in advance!

[#2]

Here Marcus !

You will be able to undersand me now !!

[marcus_sommer]

Your example is slightly different to mine and I'm not sure if it's covered your needs. I think you should extend your data and logics a little bit and makes some further attempts. I have added a few objects to see better what happens if anything will be select.

Sometimes you will get some handlings disadavantages with calculated listboxes and if you are not happy with them you need to think about other solutions. Maybe you could create such logic within the script or at least some parts from it, maybe something like this:

CurrencyMatch:

Load Tipo, autonumber(concat(UM, ' + ')) as [UM Total-ID] Resident xyz group by Tipo;

- Marcus

[#4]

I undestand what you said. But It still doensn't work for me.

I need that only PESOS and EUROS were abailable if user select more than one TIPO.

In this example, I do not know why, they can choose between Pesos and Uom. Totally stranger.

Even more, once you choce PESOS for example, the selection of the TIPOS is lost !!!!

I really need help with this!!!

[marcus_sommer]

It could be very difficult to create such solution without disadvantages then you want not select over normal fields else calculated dimensions and this is in your case more a (usability) workaround. I'm not sure if such approach to simplify the user actions is always helpful - they could loose (very important) relations to the data they are looking on.

As an alternatively you could keep your native fields and provide the users those informations as help within the listbox, for example concat(distinct UM, ' + ') as additionally expression within the listbox for Tipo.

If I understand the relation from Tipo to UM right then is they fix and not depending from selections. Therefore you should consider solution (parts) within the script (at first the and-mode).

- Marcus