I have created a series of 4 conditional value lists based on music categories showing entries from 2 fields(e.g Code No & Category - sorted by Category).

In the first value list, where each Code No is prefixed with a letter A, I can type the letter P (e.g. P for Piano/Keyboard/Organ) and I get the expected result.

In the second value list, where each Code No is prefixed with a letter B, I can type the letter P (e.g. P for Piano) I get the same expected result.

However, in the third value list, where each Code No is prefixed with a letter C, I type the letter P again (to try and get "Piano Duets") but the entry offered is the last entry in the value list - I think it may be looking at the letters in the Code No field.

Similarly I get the same result in the fourth value list.

These particular value lists exist in a separate file to the fields that use them.

It seems strange that I cannot get the same functionality on each list. As far as I know I have created and formatted the lists in exactly the same manner.

Can anyone help?

In the third and fourth value list is the field defined as a Number field?

Thanks for the response, but regrettably all are defined as Text fields