I'm building a gymnastics scoring system from scratch. I'm pretty set on the

main structure but I need some how to advice. The athletes will be entered

and sorted first by Div. then Age Group and last by Team. Scores & Places

will be in each athlete record. Here is where I get hazy. A competitive

Session could be Level 1's - 10-12 yr old and Level 2's all ages. Then at

completion of a Session [could have 10 or 12 sessions per meet] I need

individual results and possibly a Team score which could be accumulative

from another session.

In my old pascal version, I built a session table and turned on or off each

[level-age group] for that session and another table to designate which

[level-age groups] make up a particular team scores. Then at conclusion of a

session I run awards&places for that session and append 0 to 2 team scores

if needed for that session. (I need to filter out teams too cheap to enter

team competition also per level). My old dos based program works great as

long as I am there to request the correct results per session but the

database was static and we out grew it. I even PDF results to internet

website within 10 min. of conclusion.

How do I design a table that can predefine the proper result document per

session since they can potentially be so different? I'm not lazy but a bit

overwhelmed on a strategy. Thank you much, you guys have kept me creeping

forward for many years. I got the book Ted, thanks.

Gary Jeurink

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/6F1CC58687A5413A81D0CF72BBF0ADEC@OwnerPC

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.