Hoping someone can help me figure out how do do a layout that can show found values from selected records.
I have a table for a competition with 7 fields. The first field is for the match number and the remaining 6 for the teams starting positions. The teams starting positions can change from match to match.
What I want to do is to view a single match and display the 6 starting positions. And the directly below each of the 6 position fields, show what other matches that team is competing in.
|Match 2||Team A||Team B||Team C||Team D||Team F||Team G|
|Match 2||Match 2||Match 2||Match 2||Match 2||Match 2|
|Match 10||Match 12||Match 6||Match 14||Match 10||Match 6|
|Match 59||Match 15||Match 18||Match 45||Match 11||Match 14|
I assume that I would have to use a Portal for this, which I've tried. I've set up a relationships from the Position 1 Field to the Position 1, 2, 3 , 4, 5 & 6 Fields, and created a portal that's tied to that relationship and display's the match Number. When the relationship is tied to all 6 of the Position Fields, nothing show up in the portal. If I change the Relationship to be just a One to One relationship. i.e., P1 to P3, The Portal does show me which matches the team in displayed in the Main Form has also has.
So, to display what I want, I'd have to create 6 Portals for each of the 6 Starting Positions. Which seems kinda clunky. And also, I'd like to be able to see all of the matches in order, by match number, regardless of which starting position they are in.
I'm assuming there's a more elegant solution to this and hoping someone can help me out.
Thanks for the time.