Matt - There isn't a "right" answer. I'd recommend consolidating your tags into two tables: groupings and details. Create a one-to-many relationship between groupings and details, In the grouping table, add a field that reflects the type of tag (eg therapy area, job title, symptom.) That way, it will be easier to manage the data.
Conditional drop-down lists will become your new best friend. That functionality will let you limit the choices users have when tagging things. Feel free to reach out to me at
CloudBase Services for more help.
