made lookup table that takes procedure description words and keys and returns the procedure codes.
wired up the search procedure box to the database, does not query properly.
switched over to postgres, app searches by procedure, and made improvements to specialty search.
App fully functional after switching to postgres.
I'm committing now because I'm about to destroy and reseed my database.