DocMartin,
OK, I have to pay back Brian for all the many times he has THANKFULLY pared down my instructions for something and made it easier. While his description works, I think it can be much easier MAINLY because there is ABSOLUTELY no way to screw it up, hence the lack of need to do all the renaming and saving.
I would do the bottom steps in this order:
1. Open Amazing Meds in your AC folder
2. Open the Listings table
3. ADD THE NEW MED AT THE BOTTOM IN BRIAN'S FORMAT
4. IMPORTANT: Delete the MedNames and MedsDetails tables.
5. Restart AC and you are in business. AC will automatically rebuild the two tables you deleted
Trust me, I have been doing this for many, many months.
-- While I am very proud of my completely from scratch pediatric database, Brian's is an unbelievably great creation. But, there is no need to go to all that trouble.
Example: You could open the database and go to the bottom and write. "The big elephant tramples trees with no regard to the environment." Nothing would happen wrong except you would have a new elephant medication.
