AnsweredAssumed Answered

key = unique id (code) *and* human readable

Question asked by pauld2001 on May 2, 2016
Latest reply on May 2, 2016 by erolst

I'm creating a Filemaker db for a metadata class.  The db describes videotapes used to make a documentary.  I have created a table that defines the interviewees (first name, last name of course, the rest tbd) each name/record will have a interviewee code. This will be used as a Primary Key in the Interviewee Table and be a (linking) Foreign Key when used in the Camera Master table.


Because the number if interviewees is small *and* I wanted the id's to be human readable, I was going to use initials, which would be unique. However the Prof cautioned against this and advocated using arbitrary serial #'s (aka not human readable). I wonder if I can meet her in the middle by adding a number like JV1 - which in the unlikely even if duplicate initials I can make the next one JV2? (and still keep the code human readable)