Database creation for patients follow-up?

[nikolo00]

Dear friends, it's days I'm trying to create a database to store information about my patients and their follow-up, but I am having big troubles in understanding how to do it with airtable. Anyone willing to help?

Thank you 🙂

[TheTimeSavingCo]

What issues are you facing with doing it so far?

[nikolo00]

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?

[TheTimeSavingCo]

Sorry, I'm not too sure what you're asking.  Are you asking how to create a unique identifier for the first column?  If so, try making it an "Autonumber" field