Abstract: For the incompatible problems and mutual restraints in traditional Chinese medicine prescriptions, this paper introduces an automatic judgment method using data macro in Access database, in order to cue the doctor when prescribing a receipt. Data macro is similar to DML trigger in the large database, which is a great supplement to the Access database, especially to the table object function. It makes up for the shortage of the table object in process data integrity function implementation. This paper also provides a reference for solving the similar problems in Access database.

Key words: data macro, database, Access, eighteen incompatible medicaments, nineteen medicaments of mutual restraint