11 Replies Latest reply on May 2, 2016 1:29 PM by erolst

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

    pauld2001

      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)

       

      Thanks,

       

      Paul