Brian, I have an ICD9 database with 15870 codes in it. I also have a set of 333513 keywords associated with these codes. The keywords allow the user to type in "fever" and show all the codes that relate to "fever."

While that is helpful, most docs do not need the 15870 codes in the database, but rather a small subset of less than 200 codes, if even that. So the best way to do this would be to allow the doc to build his/her "basic code set" which will be instantly available at all times. This will not slow down the program.

The doc should also be able to ADD to his code set from the MASTER CODES as he/she sees the need to do so.

If you were able to access the AC database, you could run a query like:

Select distinct(ICD9Code) from tblPatientEncounter

This would give you a single instance of every code you have used in AC...a good jumping off point.

Disclaimer: I don't know what the patient encounter table is called.

Last edited by gkfahnbulleh; 07/23/2008 8:41 PM.
"The illiterate of the 21st century will not be those who cannot read and write, but those who cannot learn, unlearn, and relearn." ~ Alvin Toffler