AnsweredAssumed Answered

Health records chart numbering

Question asked by EP on Jan 1, 2013
Latest reply on Jan 6, 2013 by EricaJackson


Health records chart numbering


     Working on a health records system.  I'm trying to decide what the best way to automatically assign chart numbers for a record would be.  I've come up with: an auto enter serial that takes the initials of the first and last name and adds a number after the initials.  I know this goes against database design rules for Serial numbering, but I'm not using this as a serial for relationships, rather just a way to auto assign a chart number/ID. For example, John Doe's first record would be JDO1, his second record would be JDO2 and so forth.  Any thoughts?