3 Replies Latest reply on Mar 3, 2016 7:14 AM by jurgmay

    Using status flags

    jurgmay

      Hi all,

       

      If there are three possible states for a record - Expired, Active and Pending - what is the best way to record the status of that record?

       

      At the moment I have three separate fields - 'isActive', 'isExpired' and 'isPending' - but only one of these will ever have a value of 1 at any given time and the others will be 0. Is it therefore better to have a 'status' field and denote 'Expired' as 0, 'Active' as 1, and 'Pending' as 2 for example?

       

      Thanks in advance.

       

      Juerg