1 2 Previous Next 16 Replies Latest reply on Aug 19, 2015 7:42 AM by richardsrussell

    Database design. Help!

    famtornhult

      How should i design a triathlete-database which should be able to store results for several hundred triathletes?

      I absolutely get how I could do it but I absolutely need to be able to import results from xls to several tables.

      One table should be: TriathleteID, Name, Club, Age-group.

      The other: Venue, Distance, Swim, Bike, Run, Total.

       

      I could even have 3 tables with Triathlete as one, result as second and race as relation-object.

       

      BUT HOW AM I SUPPOSED TO IMPORT IN THE EASIEST WAY?

        1 2 Previous Next