Good question John.
I'm not a professional programmer, but I own stock in Intercontinental, which owns Holiday Inn Express, so I get some benefits from that. One thing I've learned from programming for the office is that there are lots of ways to do things, and I'm not good at picking the best practices or the most elegant way.
My guess is that the lab interface reports and the regular imports are stored in different tables. When a patients chart is opened a temporary table is made. A query appends the lab interface data for the patient and that query has descending ordering, so newest on top. Then another query appends the patients other data to the table, and I'm guessing there is no sort order so newest on bottom. It really doesn't matter the order of data in a table, but i'm guessing this is how you get your II chaos. There is another query to display the contents of the temporary table, and this query sorts by type, but not by date added, so it doesn't correct the divergence created in the temporary table.
If the final query will add a secondary order by for date added in descending sort we will both be happy.
Anyway, whether or not I'm right on the code, I'm putting you down as wanting newest items on top, right? I want to respectfully keep this matter in AC's attention.
