How should I choose whether to use one-to-many join with a link table, or to implode the values of checkbox into a string with the separator and store as a text field directly?
It really depends on your database schema. If you have an existing schema, then the decision is already made for you. If you get to decide what the schema is, I'd suggest using a link table as it gives more flexibility and provides referential integrity.
Replies
It really depends on your database schema. If you have an existing schema, then the decision is already made for you. If you get to decide what the schema is, I'd suggest using a link table as it gives more flexibility and provides referential integrity.
Allan
Thanks allan.