Manually create a value list with the events in the order that you
want. Then when you display the check boxes tell FM to sort via the
value list order.
You could create a separate layout listing the event names in the
order you wish and use the copy all feature to capture your events as
text and then place them in the value list. I am guess overall this
would save time, especially if this is a recurring problem.
Jens
Jens Selvig
...Lost in Montana...
On Feb 17, 2008, at 2:27 PM, Chuck Pelto wrote:
I'm working on a system to rapidly enter events that attendees at a
convention want to participate in.
These various EVENTS are in a table, separate from the table of
ATTENDEES.
There is a field in the ATTENDEES that is established as a CheckBox
field in which all the possible events from the EVENTS table are
listed.
The idea is that the person entering data on which events an
attendee is registering for will be checked in that CheckBox field.
I'd prefer that the events are listed in that field in chronological
order. The EVENTS table has a field for that, with each record of
each event.
The only way I seem to be able to get the events to sort out
properly, i.e., in chronological order, is to include the DateTime
field for events in the Value List; as the second field.
I'd rather not show the DateTime data in the CheckBox field. But if
that data is not selected in the ValueList set up, the events will
not sort properly. This, despite setting the Table for this
relationship, between EVENTS and ATTENDEES to sort based on (1)
DateTime and (2) Title of event.
How do I accomplish this?