Schedules

J

JCO

I need to do several schedule for a sport team. I was wondering if their
was a special form that can be used for this. I thought a schedule could be
bounded by a "tab form". The form could have several tabs that represent
the different schedules. Can this type of form be used on FP2003.

If not, my fall back plan was to use a table that represents all the
different schedule. Each name on the table could be a link to another table
that displays the schedule.

What are your thoughts?
 
J

Jim Buyens

-----Original Message-----
I need to do several schedule for a sport team. I was
wondering if their was a special form that can be used
for this.
No.

I thought a schedule could be bounded by a "tab form".
The form could have several tabs that represent
the different schedules. Can this type of form be used
on FP2003?

You would have to:

1. Create a separate Layer for each schedule.
2. Arrange all these Layers right on top of each other.
3. Make them all invisible, except for the first one
you want to appear.
4. Arrange a series of Interactive Buttons (or, for
that matter, ordinary pictures) across the top of
the area where the Layers appear.
5. Connect a Behavior to each Interactive Button or
file tab picture, and configure that behavior to
make one layer visible and all the rest invisible.
If not, my fall back plan was to use a table that
represents all the different schedule. Each name on the
table could be a link to another table that displays the
schedule.

Maybe, but what kind of schedules are these? Are they,
for example, the schedule for each team in a league? If
so, you might want create a database table with these
columns:

gamedate
hometeam
visitors

and load it up with the entire league schedule.

Then, you could use the database results wizard to search
for all records having a given team name in either the
hometeam or visitors column. This would display the
schedule for any selected team.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
J

JCO

Thanks Jim for your well thought out answer.
I will look at the layers... simply because I've never done anything with
layers before. It could be fun.

On the latter thought, all the schedules belong to the same team. The
independent schedules are as shown: Fall Season 2003, Spring Season 2004,
Spring Season 2004, Tourney 1, Tourney 2, Tourney 3, Tourney 4.... ect. It
could be done very easily with a master table that calls separate tables for
each schedule. Content of each schedule would include the same items ,
fairly simple as shown:
Date, Time, Field Name, Field #, Home-Team, Visitor-Team, Score.

Thanks for you input, I will play around with this.
 
Top