Questions from new user regarding lookup tables and cascading dropdown menus

[tdeitz]

I am new to Caspio and getting familiar with cascading dropdown menus powered by a lookup table. I have configured the menu by selecting the "parent field", "filter by", "field for display", and "field for value" options but one of my lookup table fields is not showing under "field for value" options - in particular for the last dropdown menu item. As a result, I am forced to pick a duplicate "field for value" for that menu option, which is not what I want. Has anyone encountered that problem and if so, do you have advice on how to get last lookup table field to show as a "field for value" option?  All of my lookup table fields are data type Text (255) except the field that won't show under "field for value", which is a data type Text (64000). Not sure if that has anything to do with it. 

[LWSChad]

Data type of Text(64000) is why that field isn't an option - those fields are way too large to compute in this scenario.

This is expected behavior, and is not unique to Caspio.