1 Reply Latest reply on Feb 7, 2017 4:36 AM by beverly

    Field question--Best Practices

    mbond

      I have a simple band lessons schedule.....most days the schedule is a based on periods...1 2 3 4 5

       

      One day is based on times--12:00 12:30 etc

       

      I have one field for time----however---when I sort---the 12:00 12:30 section does not sort correctly...

       

      Do you think I should break this field into ...period  and time?

       

       

      Thanks

        • 1. Re: Field question--Best Practices
          beverly

          without seeing the rest of your data, I would suggest that you have two fields. each field should be the information that is distinct to the type (time OR number) and then will sort correctly.

          beverly

           

          p.s. you can always combine them later (for reporting).