I have an Editable Grid Form which has two capture links applied to two fields. The two fields also have two Grid Lookups because they are foreign keys and I want the description to show rather than the id.
In this instance, I do not mind the id also showing but I wouldn’t mind replacing the id with the description.
SELECT and Auto Complete fields seem to be the only fields that will replace the ID with the description but then the Capture Link does not work with them for some reason.
Besides this, the pick list is too long for either of these types to be practical.
I finally adopted an integer field and used the Grid Lookup to get the description but the description is placed under the id field. The icon for the capture link is also under the field. I would like these to both be next to the field.
Any ideas on how to do this?