Forum Discussion
Solved
Trying to find who is working with
Hello!! I have a table with different authors and films. Film Author Tenet Peter Lion King Audrey Tenet Lucas And so on.. I want to filter by the autho...
In WIndows
1/ Re. They have their own idAuthor and also the films
So you would not search by [Author] but by [idAuthor] right?
2/ You earlier said "the same author may appear twice...as he has done two professions at the same film"
In this case (same film) is the [idAuthor] different for the Screenwritter [Profession] and the Director [Profession]?
>> Could you upload a picture of the actual table to hopefully clarify things please?
3/ Re. They have their own [idAuthor] and also the films so it wouln't be a problem
If you don't see any problem, given that on my side I still don't understand, you should look at the FILTER function
- I have uploaded the file.
1/That's it
2/They have the same idAuthor, no matter the profession
SO the thing is that I search for Author 3 for example and i want to know with who he has worked I mean, he could have worked in three films so I want to know all the people that worked for those films.
Sorry for my English and thanks for everything!