AnsweredAssumed Answered

Searching Multiple Table Occurrences

Question asked by MikeTrotter_1 on Jul 11, 2012
Latest reply on Jul 12, 2012 by philmodjunk


Searching Multiple Table Occurrences


I would like some thoughts on how best to accomplish this search.

I have a table (tbl_People) that has several occurrences in my file (tbl_PeopleDefendant, tbl_PeopleVictim, tbl_PeopleWitness). A persons role is indicated by their presence in the table occurrence and the same person can be in multiple tables. 

How can I best search for a person and denote which TO they are found in?

Thanks for your thoughts,