Karen,
In this particular application, employee names are almost always sorted by last name, regardless of status. For example, when you are listing employees that participated in a work order you do not need to know what their status is/was. As long as they charged hours to the work, they need to be listed. When users are reviewing pages full of names, they go straight to where the name should be, alphabetically, and 4 out of 5 times they will not think of looking at the beginning or end of the list. In my experience, the downside of using characters in front of names greatly outweighs the benefits. Again, this is just my own experience and it might work differently for other developers or applications. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, February 22, 2012 12:01 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Too relational? Javier: I suppose the "sorting" issue could be either good or bad. I never thought of adding a character in front of a name to indicate something. I could see where this would be handy. In any report, these inactive or maybe bad-credit people would all appear at the top or the bottom. Easier than looking for characters in another column. Karen In a message dated 2/22/2012 11:44:44 AM Central Standard Time, [email protected] writes: I had a client that started adding a character in front of employee names that no longer were with the organization and it created a whole lot of problems with searches, report and selection sorting and so on.
