Having some fields automatically updated on another table
This is what I want to do: when I update a patient's medical info from Patient_Illness table, I want the same data to appear on Patient table, at the Medical Info tab. I had to put the data manually as you can see from the image. But I want the users to be able to not touch Patients tab and just automatically see the Medical Info being updated as users add info to Patients_Illness, according to each patient's ID. How can I do this?
Thanks so much!