I'm about to start work on an application for a friend that's in law
enforcement. He needs to keep track of domestic and foreign victims and
witnesses (four sets of people). What I was thinking about doing was using
DomesticForeignStatus and VictimWitnessStatus fields to keep track of each
status. The information would be displayed on four separate filtered tabs
(domestic victims, domestic witnesses, foreign victims, and foreign
witnesses).

Will this work? What kinds of problems might I encounter?
(I hope explained it properly)

What database are you using? I would index the fields and use SQL or
SetRange, depending on the database, instead of a filter.

--
Bill
(TeamB cannot answer questions received via email)

I'm planning on using the Advantage local server and Advantage-type files.

I do plan to use indexes, but had completely forgotten about ranges;
thanks.

I'm a Delphi newby, so it'll probably take me a while to finish this.

On Thu, 31 Jan 2002 18:53:47 -0700, "Bill Todd \(TeamB\)"

news:b26k5uclv2qcvodeh9bkppcs6pltfl61e5@4ax.com...

Just an observation, I believe a witness can also be a victim in the same
crime. Check that with your friend. If so then keep separate flags for
these.

--
Wayne Niddery (Logic Fundamentals, Inc.)
RADBooks: http://www.logicfundamentals.com/RADBooks/delphibooks.html
In a tornado, even turkeys can fly. - unknown

news:b26k5uclv2qcvodeh9bkppcs6pltfl61e5@4ax.com...

It depends on whether there can ever be someone who belongs to
both groups, a victim and a witness. You can use a binary count
(integer field) with 3 values:
        1 = witness    2 = victim    3 = witness and victim

I doubt anyone could be considered both foreign and domestic so
that field shouldn't be a problem.

HTH
--
Woody (TMW)

----------------------
Can vegetarians eat animal crackers?
    George Carlin

Thanks

On Thu, 31 Jan 2002 23:26:02 -0500, "Wayne Niddery [TeamB]"

This application will primarily be for tracking financial crimes involving
potentially failed transactions. A victim will be a person that actually
lost money on a transaction with a perpetrator, while a witness will be a
person that didn't lose money on a transaction or a person that has
knowledge pertinent to the investigation.

Your suggestion concerning persons that could be both might come in handy
in another application. Thanks.

On Fri, 1 Feb 2002 13:29:50 -0600, "Woody \(TMW\)" <woody....@ih2000.net>
wrote: