March 19, 200520 yr Author 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.
March 19, 200520 yr 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.
March 19, 200520 yr Author 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.
March 19, 200520 yr 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
March 19, 200520 yr 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
March 19, 200520 yr 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
March 29, 200520 yr Author 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.
Create an account or sign in to comment