I have created two ECTs, let's call them country and city for clarity. I have also created an association with city as the child and country as the parent. When I create an external list for city, it appears roughly as follows:
City Country ================ ================= London 1 Manchester 1 New York 2 Los Angeles 2 Tokyo 3
When I actually go in and edit an item, I get an ECT picker which allows me to pick using the friendly names (Great Britain, USA, etc.) thanks to the city-> country association. However, I would like the external list to also display the friendly name rather than the country ID, which is just a database autoincrement and not useful at all for the end user.
Note: I'm creating a SQL server ECT, with all operations being implemented with stored procs