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?