I've a problem with cascading prompts. I have 3 fields, level 1, level 2 and level 3.
Level 1 takes the highest point in the hierarchy, then level 2, then level 3.
For some reason, when selecting values at the prompt, it does not show all values that it's supposed to show.
For example, Level 1 has a numeric value called 101. Crystal does show the majority of level 2 values available for 101 but it is now showing all of them. Level 2 has a value called 420 which the prompt does not show as a list of available values. However, if I were to select a different Level 1 value, 418... then 420 is shown as a selectable value for Level 2.
In this cascadnig prompt, there are quite a few Level 2 values in which Level 1 does share.
What can cause this?
Thanks.