OR Relationship Problem with Lookup Table
I have an issue I cannot quite find the answer for. I have 2 tables.
SCHEDULE (ID,DATE, TIME,LOCATION,HOME_TEAM, AWAY_TEAM)
I want to create a Layout for the TEAM and have a portal that shows the schedule for that team in Chronological order but I cannot get the relationship link right. I can obviously link team to home team and the portal shows all home games or link it to away team and it will show all away games. How do I link it to show ALL games?