Caspio has this feature, Display Value, nice when a joined table is being used as a lookup, with a key and a value.
But how it works seems backwards.
If I pick something from the dropdown, then I, as the administrator, see the lookup value, instead of the key, in tables.
If I check “Use display value on DataPages,” then my users see the lookup value in DataPages.
But often I, as the administrator, want to see the key while my users see the lookup value.
Am I correct that Caspio cannot display the lookup value on users DataPages unless it does the same on Datasheets?
Thanks,