Many-to-many relationships, normalized schema, using checkboxes / select_multiple

eugenio

Administrator
Staff member
At the moment, you can handle many-to-many relationships in two ways:
1) Keeping your schema normalized and using a master/details view
2) De-normalizing your schema and using checkboxes / select_multiple (options saved in one field separated by ~)
The idea is to allow the use of checkboxes / select_multiple even with normalized schemas (e.g. the use of a books_authors (id_book, id_author) table
 
Upvote 11
Top