Updating a table with a value from a mainform when a subform updates (2 Viewers)

[LarryE]

I might use a design something like this if I wanted to track record labels, genres, artists, songs and distribution:

1. Each label has multiple artists and genres
2. Each artist and genre has multiple recordings
3. Each recording may have multiple distribution types (single or album)
4. Each single or album may have multiple media types (vinyl, CD etc.)

 

[Mark_]

Please note, Genre can be very fluid. The same song will be listed under multiple genres, depending on who is asking.

 

[GPGeorge]

Please note, Genre can be very fluid. The same song will be listed under multiple genres, depending on who is asking.

That's why, in similar databases, I implement a many-to-many relationship on Books and Genres, Movies and Genres, Music (tracks) and Genres. Let everyone have their preference.