1 Reply Latest reply on Jul 31, 2007 10:19 AM by Günter Schenk

    Automatic Position Number

      I have a basic table/database set up to record a persons name, location, the number of miles travelled and their position in a race.

      At the moment all of these fields have to be entred manually when you wish to update them.

      Is there a way to automatically assign a position? (i.e. the person who has travelled the most number of miles 1st - least nth?

      Many Thanks
        • 1. Re: Automatic Position Number
          Günter Schenk Level 4
          Hi,

          it´s actually possible to calculate values of database columns using SQL -- that´s what I´d suggest doing on a "reports" page. However, before giving an specific example; I´ll need to know if the "number of miles travelled" related to person X is always getting updated in just one record or if this info is getting spread across several records allocated to person X

          Günter Schenk
          Adobe Community Expert, Dreamweaver