Show another column on the linked field



One of my tables will be filled by forms. That table has a linked field to a table that, as a primary field, has an autocompleting ID. When using the forms view, it shows only the “1, 2, 3, etc.” (image given), making it impossible to know exactly what is being selected.

It would be very useful if:

  1. I could choose what column from the table linked on the field will be shown, or
  2. The dropdown shown on the forms view could be the same we have when choosing in grid view (image given).




As a workaround, maybe you could make the primary field a Formula to add more info to the name of the record.