From what I've read it seems best to avoid using multivalue fields for a number of reasons. I haven't been able to find out the ideal way to approach it, however.
I want to design a form to capture the various countries in which a study was performed. Without using the mvf option in Access, how would I design a form to efficiently capture:
Study 1: Countries UK, US, ES, etc
Study 2: Countries IT, RU etc
I guess it's a many-to-many relationship between studies and countries, with a join table?
Thank you.
I want to design a form to capture the various countries in which a study was performed. Without using the mvf option in Access, how would I design a form to efficiently capture:
Study 1: Countries UK, US, ES, etc
Study 2: Countries IT, RU etc
I guess it's a many-to-many relationship between studies and countries, with a join table?
Thank you.