AnsweredAssumed Answered

Add historical function to sports performance database

Question asked by tomo17 on Feb 9, 2014

Title

Add historical function to sports performance database

Post

     I have a database that records the events conducted in a range of sports carnivals which I am happy with how it functions.  To increase the usability of it I am looking to add the ability of comparing year to year results and hopefully generating a list of event records. The database was based on suggestions from http://forums.filemaker.com/posts/d01e01c4a1?page=3

     I am attempting to retrofit rather that rebuild from scratch. I have added a Carnivals table to record the overall list of carnivals and this is linked to the events program via a carnivalrecordID field.

     I am currently stuck on two aspects:

     generating the points score for each carnival separately (it is currently just adding all the points together across all carnivals)

     how to generate the event bests/records so that they are also visible during the carnival when that event is being conducted.  

      

     I have attached a screenshot of my current set up.

      

     Any help would be great

      

Screen_Shot_2014-02-09_at_4.15.08_pm.png

Outcomes