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)