Or, your problem may be solved in one of two ways, depending on what you are trying to accomplish:
- If your goal is to enable users to see or report on the countries assigned to a record, then create an embedded table of assignments within the records form. Sometimes, when I've done this for users, they are more than satisfied. If they want, they can use the links in the header of the embedded table to pop it out as a separate report and add more columns.
- Alternatively, if you are trying to extract the list of assignments for a country and use it somewhere, then you might try getting the expanded query for a report on the assignments table, and using that.
I think Mark's idea is specific to putting a concatenated text field of countries onto a record in the records table ... A good plan, to be sure, provided that it better matches your objective than the options above.
