Chronological List

[ruthcarlton]

I have a DB in which a single record contains the times of events happening in the course of a day. From set up times to meals. I need to create a list of all the events happening in a day chronologically and I don't want the list in a table form.

Is there a way to create fields which determine and display chronological order?

[rdhaden]

I would suggest instead of each record being a day with different fields being different event times, make each record an event, with a relationship based on event date, then you could put events into a portal sorted by event time.

Short of that, you could have global fields on your layout and then run a script that sets each global field to the appropriate field value based on event time. But you're more limited that way because unless you have the same number of events all the time, you may will have either too many or too few global fields to account for all events.

[ruthcarlton]

Yeah, I'm coming to that conclusion. The existing DB is actually events, but within each event I have 20 or so different times to record.

The fields in the new DB will be:

"time"

"timelabel" (i.e. "breakfast", "crewcall", "lights")

"eventID"

How can the user still only enter the time in one DB, but have the new DB record both "timelabel" and "eventid"?

** I have posted a image of the original "event" db at http://www.ruthcarlton.com/screenshot.gif