This content has been marked as final. Show 1 reply
Imagine having an extra table with two fields ID and TEXT. Imagine further filling the records with your often used text phrases. Additionally you might want a value list showing all IDs and Texts
Then think of having a text field TEXT_IDS in your reports table. This field will be filled with a checkbox (not radios because you want multiple selection) connected with the value list from above.
Now think of connecting reports::TEXT_IDS with texts::ID with a relationship.
A calculation based on table reports = list( texts::TEXT ) will concatenate all the selected TEXTs with newlines.
Does this help?