J. Brian,
Welcome to AC. I am not aware of anyway to change the database directly from AmazingCharts, i.e. write a script and then choose add to database. You must edit the Access database. Microsoft Access can be daunting -- I am currently looking at a book on Access on my bookshelf which is almost as big as a PDR and probably less helpful <G>. Making large databases using Access takes some time, but editing the database takes less than five minutes to learn. Basically, you open it and edit it. Again, as I have stated in the past, there is a step there that must be done in order for the changes to save.
The only other change you can make to the AC medication scheme is to change it in the Windows registry directly. When you write a medication on a specific computer, it is saved to the registry. A total of 54 each of the medications and strength, sig, amount dispensed and number of refills are saved to the registry of the computer you are on. Each time you write a new script, those four components occupy the zero spot of the med list as MedList0, zero spot of Number dispensed as NoList0. Concurrently, #53 is deleted.
Of course, editing these would really serve no purpose as they are constantly being replaced. The only reason I used to edit the registry was at my last job, I almost always used the same three room and thus the same three computers while my partner used the other three. Because, I am OCD, I want Concerta to read Concerta extended-release tablets and to be spelled correctly. So, if I happened to type Conc..., then it would populate the medication box. But, my partner was not OCD or was on Luvox, lol (Just kidding), so he would write Conserta. Since if he wrote just one more prescription, Conserta would then move to MedList1, it would take 53 more scripts before it thankfully fell off the PC. So, when he used my rooms, I would go in and delete them at the end of the day. And, I wonder why I am here until 1AM <G>
Sorry about the longwinded answer. The short answer is I am not sure if anyone else has ever suggested it, but, no, you can't do it.
Cheers!