I AM SETTING UP A DATABASE CONTAINING RESULTS FROM PEOPLE SEARCH ENGINES. I USE 4 DIFFERENT SEARCH ENGINES TO TRY TO LOCATE PEOPLE AND CROSS REFERENCE INFORMATION FROM EACH SEARCH ENGINE.
FOR EXAMPLE I WOULD RESEARCH A NAME.
SEARCH CRITERIA: JANE SMITH (NAME SEARCH)
FROM THAT ONE SEARCH I WOULD GET RESULTS LIKE THIS:

1.
NAME: JANE A SMITH ADDRESS 1: PHONE(S): RELATIVE/ASSOCIATE:
AKA: JANE A DOE 1234 E BROADWAY (999)999-9999 JOHN DOE
DOB: 03/03/1976 TUCSON AZ 85711 (123)123-9999 MARY SMITH
BOB JONES


ADDRESS 2:
9999 N 1ST AVE
TUCSON AZ 85710

ADDRESS 3:
6676 N GRANT
TUCSON AZ 85710

2.
NAME: JANE B SMITH ADDRESS 1: PHONE(S): RELATIVE/ASSOCIATE:
AKA: JANE C DOE 1234 E KOLB (999)888-8888 LGARY SMITH
MICHAEL SMITH
ADDRESS 2: CARRIE SMITH
9939 N 2ND
TUCSON AZ 85710

ADDRESS 3:
100 N GRANT
TUCSON AZ 85710

( SO EACH NAME MIGHT HAVE MULTIPLE ADDRESSES, MULTIPLE RELATIVES, MULTIPLE PHONE NUMBERS, AND MULTIPLE AKAS)
SO AFTER RECEIVING THAT INFO I MIGHT RUN A REVERSE ADDRESS SEARCH ON ONE OF THE ABOVE ADDRESSES. OR I MIGHT DO A RELATIVE NAME SEARCH, OR A REVERSE PHONE SEARCH. THE RESULT FORMAT IS THE SAME AS ABOVE. THE RESULTS FOR EACH SUBSEQUENT SEARCH NEED TO STAY ATTACHED TO THE ORIGINAL NAME.
I HAVE TRIED MANY WAYS BUT NONE SEEM TO FUNCTION EASILY. I FEEL I AM DOING SOMETHING WRONG. ANY SUGGESTIONS WOULD BE APPRECIATED ON HOW TO SET UP THE TABLES AND RELATIONSHIPS. THANKS