"Stephanie" <(E-Mail Removed)> wrote in
news:1d9601c382c2$ff547fe0$(E-Mail Removed):
> Is there an easier way to organize my table
> or query to achieve the same result?
>
Yes: you have a simple many-to-many relationship, so that is what you
should be building. You need a new table called IsReferredToIn (or
RefersTo, if you prefer) that looks like this:
*DocumentNum *PersonID RefType
============ ========= -------
1029 398 Plntff
1029 449 Rspndt
1029 23 Author
1029 77 Author
and so on. Note that you can have multiple authors, plaintiffs etc if
required; and it becomes very simple to query for docs that refer to
particular person, or for specific attorneys, and so on and so on. This
will work much better than the current un-normalised approach.
Hope that helps
Tim F
|
Similar Threads
