AnsweredAssumed Answered

OR Relationship Problem with Lookup Table

Question asked by KevinForte on Nov 17, 2010
Latest reply on Nov 17, 2010 by KevinForte

Title

OR Relationship Problem with Lookup Table

Post

I have an issue I cannot quite find the answer for. I have 2 tables.

SCHEDULE (ID,DATE, TIME,LOCATION,HOME_TEAM, AWAY_TEAM)

TEAMS (ID,TEAM_NAME)

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?

Outcomes