I'm trying to create an on-going table that will contain data based on information in a primary table but can't quite wrap my mind around the proper solution. I've been building a local view for this data but find it is a bit slow to create (a few seconds but when you have to do it over and over again, it adds up) and am hoping for a cleaner solution.

Here's the situation. I have a table that contains information on people. It contains the usual descriptive fields such as first and lastnames, dob, etc. and each record has a unique id associated with it. Since any one person may be associated with others to make up a "team", the table includes a field called "relfile" which holds the unique id for the team leader. Here are the business rules for a team.
(a) There can only be one team leader per team.
(b) A person can only lead one team at any given time.
(c) A person can only be a member of one team at any given time.
(d) A person can NOT be a member of one team and a leader of another.
(e) A team can have an unlimited number of members.

So if we have a three member team, the table records might look like this:

Team Leader MEMBER A MEMBER B
ID '001010' '001103' '001309'
Last Alpha Beta Jones
First Mary Susan Tom
Relfile '001010' '001010'

To create new teams, I want to see a list of potential team leaders. This would include only those people who are not currently team leaders AND who are not members of an existing team. Could someone suggest a way to create and maintain a table of the potential team leaders which would be efficient and quick? Bear in mind the member table is updated multiple times each day!

Thanks in advance!!!