Return to FileMaker.com
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?
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.
p.s. you can always combine them later (for reporting).
Retrieving data ...