adding field values to selected records
I work with a field that has a bunch of multi-choice pre-defined value options (I call the field "tags"). i am looking for an easy way to automatically add values to this field in the set found as a result of ad hoc queries done in other fields.
"Command =" doesn't work, as it replaces the current values.
I prefer not to change the "tag" field to a calculation because most often I will manually add field values. When done automatically, it should accomodate not-predefined ad hoc queries that could be different each time.
Anybody any suggestions?