Piggybacking on my previous thread, I'm wondering if we should handle yes/no data the same way as we would handle a lookup with multiple values? That is, instead of using a simple yes/no option in a table, would we use a lookup table, as shown in the attached images?
(For context, the question for this table will be if the client is receiving medical case management services at another agency, with only a yes or no response being allowed for each assessment point.)
Or, instead of doing it as in the attached images, would I use no lookup table and just have tblClientServicesElsewhere, with the third row being a yes/no data point rather than an FK ID lookup?