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

Hi!
I am trying to setup a spreadsheet to share a list of common movies with my wife.
I’ve had a couple of ideas on how best to do it, but I wanted some advice on which is the “better” solution that allows for more customization, or ease of use.

Idea 1:
Create 2 tables. 1 for each partner, we both put in the movies we like (IMDB URL and Movie name)
Create a helper table, that lists all movies in both.
Create a summary table from helper table that lists all movies in helper table.
Shown in “Movies for both” table.

Pros:
We each have our own sheet
Anything we do in our own sheet does not affect the other partner’s list.

Cons:
Marking movies watched, must be done separately.
Duplicate data
Inefficient(?)

Idea 2:
Create 2 tables. 1 for each partner, we both put in the movies we like (IMDB URL and Movie name)
Create a summary table from one of the lists.
Filter based on that summary table.

Pros:
More filtering/sorting available in movies for both.

Cons:
List is only showing 1 person’s list, only highlighting what’s also in the other list.
Duplicate list.

Shown in “Movies for both v2” table.

Idea 3:
Create 1 movie table, with a column to label who’s movie it is.
Filter different views based on that 1 table.

Pros:
1 table. More efficient.

Cons:
Manually label each movie for who added it
Can end up with a lot of empty rows if using the filtered table to add movies.

I’d love to hear thoughts on what’s best on how to make this, and if my ideas are silly, or if they’re on the right track for the best way to do this.

I’d want a way in which my wife and I can copy/paste the IMDB Link, with each of the movies we each like in separate lists, or marked with our name so we know.
Then a combined list showing what we both like, that way we have a nice list of movies we both are interested in watching.

Thanks for reading, would love to hear some feedback!
Have a great week.

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?)

Oh wow, yeah ok then that solution is by far the best immediately.
Thank you! Had no idea I could do that.

Keeping everything in a single table is definitely best! Since there’s a likelihood you will add a movie that your wife is already added or vice versa, you could add conditional formatting to show when a movie title was added twice to the list. See example formula here: Formula cheat sheet - Grist Help Center

I would recommend using some sort of trigger formula to set the formatting for movie titles so it is consistent, as values returned in formulas are case sensitive. Otherwise, the conditional formatting might miss a match. Let’s say you enter The Hangover and your wife enters The hangover. It won’t recognize those as the same value because hangover is not capitalized in the second value. This webinar clip walks through how convert a value to a specific case (lower/upper/title) automatically: https://www.youtube.com/watch?v=evZQiz2kRqo&list=PL3Q9Tu1JOy_4p4g-uS_3LQrB_3Vm7CWe4&index=25&t=775s