So far, I created a main table with the list of patients, their demographics and a unique ID for each patient as 1st column. Now, I need to associated for each patient one or more events, that could be surgeries and follow up visits. Each patient can have more than 1 event, but each event can be associated to only 1 patient. Accordingly, I created some tables for the events and linked them to the main table. However, it seems that each event must have a unique identifier (first column), while I'd just need to visualize in the main table the number of surgeries and the date of the last one. How can I do that?
