display 2 records on one layout

[aeneas07]

Ok, I have a DB for a sports league. 2 realted tables-1st table contains team name, captain name, etc and the 2nd contains all the players and their id numbers. They are related by an index field. I have it set up now so you can choose the team name from a drop-down menu and all the info and players are displayed via a portal...but I need to be able to display 2 teams that I choose from the menus and their respective information side by side on the same layout.

I can't seem to find a direct way to do this, can anyone help. Much appreciated.

[aeneas07]

Ok, I have a DB for a sports league. 2 realted tables-1st table contains team name, captain name, etc and the 2nd contains all the players and their id numbers. They are related by an index field. I have it set up now so you can choose the team name from a drop-down menu and all the info and players are displayed via a portal...but I need to be able to display 2 teams that I choose from the menus and their respective information side by side on the same layout.

I can't seem to find a direct way to do this, can anyone help. Much appreciated.

[aeneas07]

Ok, I have a DB for a sports league. 2 realted tables-1st table contains team name, captain name, etc and the 2nd contains all the players and their id numbers. They are related by an index field. I have it set up now so you can choose the team name from a drop-down menu and all the info and players are displayed via a portal...but I need to be able to display 2 teams that I choose from the menus and their respective information side by side on the same layout.

I can't seem to find a direct way to do this, can anyone help. Much appreciated.

[David Holmberg]

My solution would be...

create one more apperence of your "player table" in the relationship graph.

create another index field

relate them

put a duplicate of the portal+fields on the layout and change them to the new relationship

[David Holmberg]

My solution would be...

create one more apperence of your "player table" in the relationship graph.

create another index field

relate them

put a duplicate of the portal+fields on the layout and change them to the new relationship

[David Holmberg]

My solution would be...

create one more apperence of your "player table" in the relationship graph.

create another index field

relate them

put a duplicate of the portal+fields on the layout and change them to the new relationship

[aeneas07]

ok so now I have these tables: teams, players and 2 additional instances of players named players 1 and player 2.

how should I set up my layout, if I set it up using players as main table and use 2 portals, one for players 1 and one for players 2 then it works until you click out of it and then it jumbles all the records together.