Relationship is almost working. Just a little more help

February 9, 200817 yr

I have a sticky problem, at least it has been for me, and I am hoping someone will see the error of my ways and get me back on track.

I have included a simplified Relationship graph that may help.

I receive from another source two files (in Yellow) that represent detailed info of the members and a file of de-normalized file of assignments that include the team and district. During the import process I will split out the district and team info (in blue) to make this data more normalized.

From the perspective of Team I want to include a portal that will list all of the teams in a specific district and by selecting on that district show all of the assignments that team has. This is accomplished with the District_Selected and Team_Filtered tables (in red) and is working now.

But what I want to display is a list of team members as a single list rather than as a team. I added the Members_Detail 2 TO facilitate this ability (team members are also in member details). As far as the portal, I can in fact get it to display the members individually. But I can not seem to get a satisfactory script that when a record in the portal of Member_Details 2 is selected to find a list of team members in team. Team_Filtered works but Members_Detail 2 does not.

The ui_District_Popup is a simple value list that populates the district causing the relationship to work on District_Selected. I then display the list of teams from Team_Filtered. A simple script is fired when one of the teams is selected. (Go to Related Record [ From table: "Team_Filtered" ; Using Layout ] ). But the same script fails when the from table is changed to Member_Details.

I thought I would have to break Assignments into a separate table with each team member being a record. I tried that as well but it didn't work either and added complications in other areas. This seemed to be the simplest solution overall, but I can not get it work.

I'm sure this is as clear as mud, so if you have question, please ask.

Thanks

Jesse