using an existing unique number as primary key.
I am a doctor and have a list of patients with pre existing patient numbers which are important for anonymisation. I would like to use this number as the primary key to link demographic data on several tables. Searching it seems that FMP usualy likes to generate its own serial number as the primary key. Is there a way I can use the pre existing unique patient number ?.