Thanks for a great community and broad documentation!
I tried to search an answer to this, but didn’t really find one. Is there a possibility to generate a dropdown menu that shows values represented in one form, but saves the chosen value in another form?
If I have the tables Persons, Participants and Seminars; for a seminar;
lets say the Seminars table looks like this:
If I open the Persons table, and for a given row press Expand row to open the modal with linked tables (subforms), I am able to enter all the seminars that person has attended, by choosing the seminar from the dropdown select menu linked to the Seminars table.
However, in the dropdown menu, I would like to see not only this, as values to choose between in the dropdown menu:
Sustainable development seminar
but rather this:
01.08.2018/Sustainable development seminar/Madrid
and still only the seminar name (linked to the seminar table) should be stored in the row field after having done the selection from the dropdown menu.
Having only the seminar title appear in the dropdown menu is too little info. It is handy to have also dates and cities in the listing of selectable elements, to be able to filter the dropdown selection better to narrow down the seletion when choosing the right element.
I am able to easily generate a column in the Seminars table with the concatenated values from Seminar + Date + City. How could I make the values shown in the dropdown menu to be generated from that column, while saving only the proper value from the Seminar column?