I have the following structure that I have to follow.
Movies People People Types (Actor, Cameraman, Director)
Where Every Person HasMany People Types And Every Movie HasMany Person
That is, Each movie will have the fields Director, Videographer, etc. Where People will be selected that are of this type.
The way I'm doing is not giving the expected result.
The list of tables is thus
People link
Tables and Relationships link
The idea that is in the admin, can be registered how many people is needed within each genre, actor, director, etc.
When I insert the data into the pivot table
it gets overwriting the values
If the person has been previously registered in another type
it overwrites