Thank you.... I was wondering if I can ask one more question? I am working on a hockey tournament and I have set up three tables. (One is the master for the divisions, the second is the Teams Lists/Standings and the third is the Schedule). I have built a relationship between the Divisions and Team Lists and further built a text function field that shows the teams division - name in a single field. I have been trying to set up another relationship between the Schedule and the team Lists/Standings with the proxy field being the text function field of Divison-Team Name. But when I open the drop down to select, instead of showing me the named division, it gives me the reference field for the division (numerical) followed by the team name.? If the Div-Name field shows up correctly in a report, why won't it show up correctly as a proxy field in a relationship?
