Surgical Database Help Please
I'm making a complex database for tracking surgeries and patient outcomes.
I'm brand new to Filemaker.
I have a simple issue that one of you perhaps could resolve.
Table 1 - Patient Information
Includes ID_patient and multiple other factors like DOB, etc
Table 2 - Tumor Information
Includes ID_patient, ID_Tumor (each tumor needs a separate identifier), and more information about each tumor, size, etc.
In one Layout (Table 1) I've got a portal for Table 2 to list all of the patient's tumors
I'd like to have a field that automatically creates a consecutive number starting from 1 to say "this is this particular patient's tumor #1" etc
I also want "Tumor ID" to be generated accross all tumors of all patients.
I'm just confused where to put the "tumor count" field for the particular patient
Thank you for your help!!!