Hi everyone,
I need to mass replace some procedure codes in future appointments to accommodate a change in the way we build our hygiene appointments. There are several hundreds of such appointments already scheduled. Needless to say that I am not thrilled with the idea of having to manually edit and update them one at a time... I cannot update the existing procedure codes table to reflect our new way of working as it would also be changing those codes in completed appointments.
I'm contemplating the idea of building a query that will identify then update these appointments. For those procedures that need to be changed, it would modify the codenum and procfee columns of their records in the procedurelog table then it would update the procdescript column in the appointment table, so that the schedule looks fine too.
Would that work? Is there something else I need to change, am I missing something?
Thanks.
Mifa