One field-3 files-3 value lists

[Ugo DI LUCA]

Hi everybody,

This is another kind of conditional value list.

It allows you to display for one field only a different value list, coming from different files.

Choose your relationship

MultipleVList.zip

[alex.v]

Thanks Ugo,

Thats a pretty handy example of something I want to do. I notice that the information appears in the address box after you use the enter key twice or with a mouse click.

As a newbie, looking at your relationships and field definitions, I find them incredibly complex.

[Ugo DI LUCA]

Hi Alex,

If you just want the different value list to appear, this sample could become very simple. Instead of a loop/exit script, you could use a simple button next to your value list field and slightly modify the script attached.

The look-up from Modification key may appear complex, but you will certainly come accross situation where you will use it (to index unindexable calcs- See the Article section).

Once the values are brought into the field, there is unfortunately no way for FM to identify from which file these records came from and target the relook-up to only that specific file. In that case, the workaround proposed here :

1. Relookup datas from the 3 files

2. Use a calculation to identify which of the three fields is not empty

3. Re-lookup the information from the not empty field.

Thanks anyway for the feedback.

[oilman]

Thanks Ugo for the example

Lionel

[Ugo DI LUCA]

Another very simple adaptation with checkboxes. Could be used for multikey...