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,