Question

I am creating some filters to show only the content for each one of the users, in this case players.

I have a table for Players.
Player 1
Player 2
Player 3

I have a table for Games.
Game 1
Game 2
Game 3

I have atable for Scores.
Score 1
Score 2
Score 3

I related the databases with the Players and then filtered them by player, so the user only see their data.

In Games I filtered using the "Self Reference" that include the Player.

In Scores I filtered again using the "Self Reference" that include the Player.

The problem is in Players, I can't "Self Reference" by Player, because it is the Players Table and not a relation.

How should I create that Filter so the Players table only shows the Player itself when clicking the template button?

Thanks.

Answer 1

Okay, so I am not sure what you mean by template button but whether its a template or a database you will have to create a property either select or person property type for your database.

You can then filter your database view by the person property or select property type.
Where the options correspond to the players for "Self-Reference".

Answer 2

Follow the instructions Avidnotionuser mentioned and either make it a general database so you can self relate or create a secondary player column and self reference that way. Then I assume you are copying those table views and pasting in template buttons. Hope that makes sense.