Matthew Snook
NW Salmon Database
- Local time
- Today, 01:25
- Joined
- Apr 19, 2001
- Messages
- 133
I have a form based on two tables:
Tbl_Entity
Entity_ID
Entity_Type
and various attribute fields
Tbl_Event
Event_ID
Entity_ID
Event_Date
and event attributes.
The two are joined one entity to many events through the Entity_ID field. The join works well, all associated events appear in the subform containing the "Events" table. But they are in the order entered. I would like to have them ordered by date. I have tried sorting the actual events table, applying an "Order By" in the sql statement. None of these have any effect on the order of records in the subform. What am I missing? There must be some setting that I have missed that is overriding these methods of ordering the records. Any ideas?
Matt
Tbl_Entity
Entity_ID
Entity_Type
and various attribute fields
Tbl_Event
Event_ID
Entity_ID
Event_Date
and event attributes.
The two are joined one entity to many events through the Entity_ID field. The join works well, all associated events appear in the subform containing the "Events" table. But they are in the order entered. I would like to have them ordered by date. I have tried sorting the actual events table, applying an "Order By" in the sql statement. None of these have any effect on the order of records in the subform. What am I missing? There must be some setting that I have missed that is overriding these methods of ordering the records. Any ideas?
Matt