@maxk42 approach with the relationship table works well for both read and write intensive applications.