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!
Simply place fields from Patient Illness table onto the Layout based on Patients table. As long as the tables are properly related this will work. You don't need fields in one table that duplicate the data in the other.