That is a very good idea. A lot like another EMR I know. It's a little different concept, which I am not sure I completely understand. And, I am not just saying this 'cause I did it a different way.
With a full-fledged (every medication in it to start) database, you would always know the different formats and strengths of a medication. For instance, Amox...would bring up Amoxicillin, and you would know it came in a solution, a chewable and a capsule and what strengths it comes in, which definitely keeps you out of the PDF a lot even though you may have spent two months in it.
So, are you saying that if you write Concerta extended-release tablets 36 mg, 1 po q AM; that you could search for Concerta and that would be found in the Search the Med Database field or in the actual prescription writer fields? It is strange, but we do have a database of frequently used medications only it is a bit strange how it works, in that it is in the registry and only has 54 entries. It places the medication into the prescription writer field, and you can either use that or edit it. I am not sure why it picks some same medication over another, though.
I am not sure if you could have two separate databases, as AC wouldn't know which one to search.
"We'll have to be able to opt-out of the updates which will rewrite all of the data. I'm having the same problem with the spell check. It gets reset when I update AC. Not sure what format the spell check is kept."
You could still update AC. Generally, when updating AC, I do a fresh install anyway. Hopefully, one would save all of the databases including the AmazingMeds. You would simply put that database back in and you would have your old database again. I did run into a problem once when AC went from Version 1 to Version 2. You will know, because it won't be able to access the medication database. You can either go back a version or simply change the format of the database to match the new one.
Roy, the spell check file is the userdic.tlx file. You can open it using a text file and see all your words there. I haven't had much luck inserting words manually, but you can insert manually through the dictionary in AC. Again, copy and paste that file or change the suffix to .old so it isn't overwritten.
I think it may be doable, but I am not sure where the data would be put once it is accessed. Just asking in case I can add some input.
