Why would certain choices in a conditional value list work, and others not?
I am really scratching my head on this one. I have a table that has a Category field and a Product field. These fields show in in a portal on pretty simple layout. I have it setup so that when the user selects something from the Category field (Drop Down), they are presented with only related records in the Product field (drop down).
Some of the categories work fine, they show all available products. Others show only a few products along with a "?" at the bottom of the list. Others show nothing at all except the "?".
When creating the table, I used a Custom Value List to select the category, so there are no issues with spelling. I use the same Custom Value List when selecting the Category in the portal, so I know that they match.
How could selecting a particular Category call up two of four matches? It either works, or it doesn't right?