Mark The simple answer is that I did not appreciate that each team/club had a "List" which when combined with "Active" players provides the drop down lists for each team. Once I cleared out all the dead wood from each team and ensured everyone was active and had the right (correctly spelt) alias, everything slipped into place. Simple not going deep enough into the product.

Mark The pools field won't work as it is not a person specific field rather its a match specific field. Basically, I want to be able to set the reports up such that when people go into the Players and Officials page they are only present with the ADF Players (not necessarily people who have played for the ADF Team but all the members that have represented When people the Australian Army, Navy and Air Force. If you look at the first screen of our list, the first Cricket ADF, Australian Army, Royal Australian Navy or Royal Australian Air Force person doesn't show up until well down the list. Hence why I would like to be able to create a background filter for the ADF Pers. Also, would it be possible to have a filter system on the public side that allowed you to filter by club, season, active, and pool? D

Mark That will only provide the details for player who have played for the ADF. By ADF players I actually mean players who are members of the ADF (including those who have only played for their respective service). Cricket ADF is the overall Association, while Army, Navy and Air Force are the clubs but we often have 'visiting'clubs in our competitions and our Rep Side plays external clubs. When using the v11 database, we simply gave all ADF personnel a 'Rating 1"and used that as a filter when running statistical reports. That no longer looks like it is available.

Mark How do I filter the lists that are presented to people going to our site so that it only shows the ADF players in the list rather than all the opposition players as well? D