Displaying 1 result from an estimated 1 matches for "datecommit".
2006 Feb 06
0
Sorting records from multiple tables, on different fieldnames
...istics, which is why they''re in
different tables), and I want to present all the records from all 3
tables in date order in an "Upcoming events" view. To make it more
challenging, there''s multiple date fields in each of the 3 tables, so
I need to sort on the field "datecommitted" from the first table,
"datedue" from the 2nd table, and "reviewdate" from the 3rd table.
This is what''s known as an "unforeseen requirement", otherwise known
as the "Actually, you know what *would* be great, and we *should* have
requested this u...