Assoicating Records

[dmkeith2]

Hi,

I've posted this question to other forums and have had no luck. I'm
currently creating a database for someone who is private investigator.
It is important to him to be able to see account numbers, addresses,
phone numbers, etc that are linked to the current person he may be
investigating. I have several subforms setup and a subform within a
subform for Associated Records, I can't seem to get the query to pull
up identical records like a husband shares an account with his spouse
who may be in the database. Below is the specific question I asked on
another forum, hope someone can help. Thanks

I have a main table and several other tables with referential integrity
to
the main table.

My database is setup so multipe addresses, bank accounts, phone number,
vehicles, etc....can be inputted and related to the main table which
has
all the personal information EIN, Business name, SSN, etc.

I create several TABControls on a form that display the data assoicated
with the main table as I change records.

I now have to do an associated tabcontrol, where I click on associates
and
I can see all the other personnel entered on the main table that share
the
same bank account, address, phone number, or vehicle, etc///
If you'd like to see screen shots of this database it is at
http://armydatabase.com/current.html

My main table and a sub-table (so to speak) are below:

tblPersonalDataSheet
CaseNumber
SubjectID (Primary Key/AutoNumber)
BusinessName
DBA
EIN (forces referential integrity)
LastName
FirstName
MiddleName
AKA
DOB
SSN
FBINumber
USMSNumber
SIDNumber

tblAccounts
AccountID (Primary Key/AutoNumber)
EIN (forces referential integrity)
SortNumber
AccountNumber
Type
Institution
Source