I need either SQL code or Visual Basic code to populate 2 junction tables (associative tables) in a patient treatment plan database.
I need to insert (or add) the Patient# from the patient table and the DD_CODE_ID from the DD_CODE table into the Patient_DD_Code table. And insert (or add) the Patient# from the patient table and the TX_Category_ID from the TX_Category table into the Patient_TXCategory table.
Do I write this code in a query or on a form with a command button? I'm not sure where to write the code for this.
Thanks for any help you can give me.