Bert,
Apologies for the confusion.
Yes, AC could have a table for active meds and one for inactive. Whenever an active med is made inactive, the now inactive med is moved to the inactive table. Users, by default, would see only active meds. If users wanted to see all meds or just inactive meds, they can click a checkbox or radio button indicating as such. The EMR could then show one table, or the other, or both at the same time.
Other EMRs do work that way and they do it for the sole purpose of your thought - to save retrieval time. Others, like AC, use only one table and an inactive field set to 1 or 0.
JamesNT
.png "ACUF Donor I")
