Click here to Skip to main content
15,881,801 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I'm trying my hand at a LightSwitch (VB) web application for my local hockey club. I have the data set up as a number of relational tables

One table is called Game/s with
ID
Round
HomeTeam (A relationship with a table of Team/s linked as HomeGame on that table)
AwayTeam (A relationship with the same table of Team/s)
Stadium
HomeTeamScore
AwayTeamScore

Obviously I have another table called Team/s which has all teams in the League. This basically has name/ mascot and contact details and has a collection of home and away games as a result of the relationships shown above.

I also have tables for players and for basic player-game stats

My trouble is if I do a list/detail screen for Teams, this gives me a collection of Home Games and a collection of Away Games that I can display on a couple of TabControls. Neat but - is there a way I could get the full list of both collections on one Tab?

Apologies in advance if this is indeed a basic question but my googling and MSDNing isn't helping much
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900