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: [email protected] 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.
