I have a file that access several SQL external data sources.
Most of the value lists are set up to read the PK for a particular table, and display some text field in the value list. They all work, apart from one particular list which works fine on the client, but on Webdirect does not display the text field. This was not a problem with FM13, from which we have just upgraded.
Has anyone come across this before? The only possible difference I can see between the working and non-working value lists is that the one that doesn't work has a text PK, whereas all the others have an integer PK. Any thoughts?