Karen: Early on, I discovered that the simple pre-pend approach is useful for binary current-status distinctions only. To track more than two states, current or over time, it became necessary to build a status-flag-and-date structure outside the pre-pended-data column; resulting in very limited functionality relative to an approach with discrete status columns.
I vote for Javier's approach, leaving the raw data values to speak for themselves. Bruce > -------- Original Message -------- > Subject: [RBASE-L] - Re: Too relational? > From: [email protected] > Date: Wed, February 22, 2012 10:00 am > To: [email protected] (RBASE-L Mailing List) > > > 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. > > > >
