Help with more Advanced functions

I have been able to get several basic databases to function both in playing
around and functional ones on the web but they have all been pretty simple.
I am now trying to develop a database for the web using Access. What I am
really needing help with is how to actually reduce the number of record sets
that I think i am going to need. Here is what I am trying to do.

I am having people sign up and create teams. So you come to the site and you
see Team 1, Team 2... Team 8. (These numbers will later be replaced by real
names given by the team captains and replaced in the database, this will be
done by the captain through the web)You pick a team you want to be on, enter
the info and you are placed on that team (in the database) I have two tables
in the database TeamRoster (everyone on all of the teams) and Teams (List
the captains and the names of their team)

So when I query the database to fill the tables I am confused as to how I
should go about the query. As I see it I need to build a RS (Record Set) for
each team to get the name of the team for the appropriate table, then
populate it with the players for that team (repeating region) if there are
eight teams, that means 16 RS. This does not seem right.

Am I making any sense?

Thanks for trying to understand all of this.

Houston"Houston" <houston@.hbip.com> wrote in message news:<jSgUc.1240$jj.803@.newssvr23.news.prodigy.com>...
> I have been able to get several basic databases to function both in playing
> around and functional ones on the web but they have all been pretty simple.
> I am now trying to develop a database for the web using Access. What I am
> really needing help with is how to actually reduce the number of record sets
> that I think i am going to need. Here is what I am trying to do.
>
> I am having people sign up and create teams. So you come to the site and you
> see Team 1, Team 2... Team 8. (These numbers will later be replaced by real
> names given by the team captains and replaced in the database, this will be
> done by the captain through the web)You pick a team you want to be on, enter
> the info and you are placed on that team (in the database) I have two tables
> in the database TeamRoster (everyone on all of the teams) and Teams (List
> the captains and the names of their team)
>
> So when I query the database to fill the tables I am confused as to how I
> should go about the query. As I see it I need to build a RS (Record Set) for
> each team to get the name of the team for the appropriate table, then
> populate it with the players for that team (repeating region) if there are
> eight teams, that means 16 RS. This does not seem right.
>
> Am I making any sense?
>
> Thanks for trying to understand all of this.
>
>
> Houston

It's not really clear from your description if you're using only
Access, or Access as a front end to MSSQL. If you're using MSSQL, you
would use queries (preferably inside stored procedures) to return data
such as the complete list of teams, the list of team members for a
specified team etc. How you then format and display that data in
Access, I have no idea.

If you're not using MSSQL, or if you need more information about using
RecordSet objects, you should probably post to an Access or ADO group,
with some more details about exactly which software you're using, and
which client libraries. If you are using MSSQL, then it would be
useful if you post the CREATE TABLE statements for your tables, as
well as sample data, so that it's easier to understand what you're
asking.

Simon