My only reason for doing it was to avoid having the dead folks pop up in regular name searches. But I really don't like it. I'm thinking of using the same dtin dtout rationale I use for employees. In my emp table, dtin is when hired, dtout is when fired or whatever, so all current emps are those with null dtout fields. So all living people (and live businesses/orgs) will have null dtout fields.
On Wed, Feb 22, 2012 at 10:00 AM, <[email protected]> wrote: > 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. > > > -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
