here's the problem: i have a table "Player" and a table "Team". Each team has a some players and players can play in more than one team. So i created a foreign-key-only table "PlayersInTeams" with many-to-one foreign keys to "Team" and "Player". In my project
(VS 2010, ASP.NET 4, C#), I would like to make teamlists of players. The default filters for the "Player" reference only to "PlayersInTeams" instead of "Team" and vice versa. How can i manage this?
Tillmann
Member
19 Points
16 Posts
Creating a Filter for Foreign-Key-Only Tables
Apr 26, 2012 02:37 PM|LINK
Hi there,
here's the problem: i have a table "Player" and a table "Team". Each team has a some players and players can play in more than one team. So i created a foreign-key-only table "PlayersInTeams" with many-to-one foreign keys to "Team" and "Player". In my project (VS 2010, ASP.NET 4, C#), I would like to make teamlists of players. The default filters for the "Player" reference only to "PlayersInTeams" instead of "Team" and vice versa. How can i manage this?
Regards
Tillmann