Just wondering if you could put the inactive meds and the active meds in different tables and just bring over the active meds. You don't need to access the inactive meds often and it would save time loading the script writer. Or do I have SQL all wrong?
