Greetings,
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?
Regards,
Chuck