My client wants users to do data entry in list layouts. I've created a field-based value list using values from the primary key field of the look-up table but only show values from a second descriptive field. On the list layout I've placed a drop-down list control based upon this value list. I've also placed an edit box control, with a solid white fill based upon the descriptive field in the related table, above the drop-down list. Unfortunately the cryptic primary key field values in the drop-down list can be seen through the edit box control. Can anybody suggest a solution?
I should also mention that I'm using FileMaker 12 on this project.