I suspect the answer is going to be quite straight forward but I just can't seem to think of it. Also I'm new to the forum so apologies if I don't give all information needed etc.
So I have a database with a table of students, this is in turn linked to a team, a student can be a member of many teams and a Team will have many students etc. What I want is a form which allows you to select the team and then displays the possible student members based on attributes (so if the team is a girls team for year 8s then the list shows all females in year 8). Then I want them to be able to tick the students who they wish to be a member of the team and save the changes.
It feels like it should be really simple to do but I just can't get my head round it.
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.