Hi All,
I have a database with 2 tables. A Members table and an Issues table. In the Members table, I have the PK as PatientID. I am trying to determine the best design method to link the Members and Issues table. Is it good design to have the PatientID also in the Issues table? I have read comments while researching this that state not to save the same data in two places. What would be the best practice with this?
Thank you!