Solution for shared movie list between partners (view data from 2 tables | Split 1 table into 2 filtered tables)

Concerning
“Cons:
Manually label each movie for who added it”
This is not necessary since it can be automatically added with a trigger formula
(see Can I get current user on formula?)