Best practices for value lists
My solution needs a lot of value lists, and many of these lists will need to be modified by the users. For example: common medications, common techniques, etc. I see as part of my orientation process having new users fill in these lists.
What is better - to create the value lists as tables (such as Meds, or Techniques, etc.) or figure out how to have them as custom lists? I see the problem with tables is that they are more difficult to add records to on the fly - for example if a user pulls down a list and their choice isn't on it and they want to quickly add it.
So - any advice? Tables or custom lists? Thanks.