AnsweredAssumed Answered

Surgical Database Help Please

Question asked by tropicoj on Jul 13, 2011
Latest reply on Jul 14, 2011 by tropicoj


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!!!