Pop up lists are blank in find mode

[Matthew F]

O.K. I'm not sure what I've done wrong but my pop lists are blank in find mode. My database makes extensive use of conditional value lists which display custom values in pop-up fields. These all work fine in browse mode but are now blank in find mode.

My value lists are based on a relationship with another file where the match field is called "User". Previously the pop up lists would work fine in Find mode as long as I would first enter a value in "User" and then click on the field with the pop-up. Now all of the pop-ups are blank.

Any suggestions?

[CobaltSky]

Hi mfero,

The most common explanation for value lists failing in Find mode is that the relationship they are based on has a calculation field as its left-hand key.

The reason is that calculations (and relationships based one them) are disabled in Find mode so that unintended find criteria will not be generated as 'results' of the criteria you actually enter. Generally this is fine, but not if you are actually depending on relationship based value lists in find mode.

I'd hazard a guess that you may have - at some stage - included a calc somewhere in the relationship chain, and that your value lists stopped working in find mode from that point onwards?

If that is the case, one solution would be to set a look-up or auto-entry calc to store the key field value and then adjust your relationship to use the stored field instead of the calc. Another solution would be to script your finds and have the script first take the user to a layout which has a special global field for the first selection (and a special relationship and second list to allow them to make the selection - solely for the purposes of the find...).