0 Replies Latest reply on Feb 9, 2014 12:25 AM by tomo17

    Add historical function to sports performance database

    tomo17

      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