[Solved] Many to many to many relationships
Posted: Mon Apr 15, 2019 9:11 pm
Hi,
I'm just learning Open Office Base and I've just figured out how to do junction tables.
But I'm struggling as the database I want to build is for books that will have multiple writers, and the writers can also be the artist.
So I've a content table
a content_personnel junction table
a personnel table
a personnel_role junction table to describe the many roles a unique person many have.
a role table to show all the roles a person may have, writer, artist, etc
But I'm struggling to create a way of designing this on a form, I've figured out how to do a subform to add the various people.
But I'm struggling to see how I can then show their role (which can be many) for that person on the book.
so many books, with many creators and many roles.
Do I need something like creating a primary key to make the person as writer unique in the junction table?
I'm just learning Open Office Base and I've just figured out how to do junction tables.
But I'm struggling as the database I want to build is for books that will have multiple writers, and the writers can also be the artist.
So I've a content table
a content_personnel junction table
a personnel table
a personnel_role junction table to describe the many roles a unique person many have.
a role table to show all the roles a person may have, writer, artist, etc
But I'm struggling to create a way of designing this on a form, I've figured out how to do a subform to add the various people.
But I'm struggling to see how I can then show their role (which can be many) for that person on the book.
so many books, with many creators and many roles.
Do I need something like creating a primary key to make the person as writer unique in the junction table?