To put the inactive meds in their own table:

SELECT * INTO MyInactiveMeds FROM ListMeds WHERE Inactive = 1

Delete inactive meds from the table so they no longer show up in AC.

DELETE FROM ListMeds WHERE Inactive = 1

NOTE: Make a backup of your database first.
NOTE: Adding the inactive meds back later because you changed your mind is not a procedure I will place on a public forum. The procedure could change over time.
NOTE: You do this at your own risk. My rate is $85/hour if something goes wrong and you need help.
NOTE: I have several ongoing projects and my availability is thin right now. Choose your course of action wisely.
NOTE: I'm not aware of any table that refers to the sciptID field as a foreign key. But I could be wrong.

JamesNT

James Summerlin
My personal site: http://www.dataintegrationsolutions.net
james@dataintegrationsolutions.net