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

Reply via email to