What I want to see is when I do a search for example for ABC Company
I would like to see all of the directors, shareholders and officers
associated with that company. Note that there can be many
directors/shareholders/officers for each company as well as the same
directors of 1 company can often be directors of another or even officers or
shareholders. I think that the table I am using may be interfering. I
imported an excel sheet for my table. This is the data that our old database
exported to excel.

Company Name Incorporation # Date of Incorporation
ABC Company 123456 12/01/1977

SD&C File # Directors Last Name Directors First Name
01234 Doe Greg Doe Greg

Officer Last Name Officer First Name Shareholders Last Name
Smith David Carter

Shareholders First Name
Aileen

It then repeats and has all the same information on the next line but this
time with David Smith as the next director. So basically I may have 5
different entries for the same company because there are 5 different
directors/shareholders/officers. One entry for every new name in any one of
the 3 columns (director/shareholder/officer). I want to show all associated
persons with the one company for each of the categories...keeping in mind
that each entry has the same Company name, incorporation #, date, and sdc #
and I only want to see that one company whereas with the combo box that I
created when I click on it, it shows me all of the companies as if for me to
select one in a list..I don't want to select I want it to give me all the
information. I hope this makes sense.! and thanks for the help

I noticed that you have also posted the same original question to
another newsgroup.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), crosspost by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.

(Thanks to fredg)

--
Clif

"pupkiss1965" <(E-Mail Removed)> wrote in message
news:BDC57009-5735-4167-967E-(E-Mail Removed)...
> What I want to see is when I do a search for example for ABC Company
> I would like to see all of the directors, shareholders and officers
> associated with that company. Note that there can be many
> directors/shareholders/officers for each company as well as the same
> directors of 1 company can often be directors of another or even
> officers or
> shareholders. I think that the table I am using may be interfering. I
> imported an excel sheet for my table. This is the data that our old
> database
> exported to excel.
>
> Company Name Incorporation # Date of Incorporation
> ABC Company 123456 12/01/1977
>
> SD&C File # Directors Last Name Directors First Name
> 01234 Doe Greg Doe Greg
>
> Officer Last Name Officer First Name Shareholders Last Name
> Smith David Carter
>
> Shareholders First Name
> Aileen
>
> It then repeats and has all the same information on the next line but
> this
> time with David Smith as the next director. So basically I may have 5
> different entries for the same company because there are 5 different
> directors/shareholders/officers. One entry for every new name in any
> one of
> the 3 columns (director/shareholder/officer). I want to show all
> associated
> persons with the one company for each of the categories...keeping in
> mind
> that each entry has the same Company name, incorporation #, date, and
> sdc #
> and I only want to see that one company whereas with the combo box
> that I
> created when I click on it, it shows me all of the companies as if for
> me to
> select one in a list..I don't want to select I want it to give me all
> the
> information. I hope this makes sense.! and thanks for the help



--
Clif
Still learning Access 2003

Sorry about that...I wasn't sure where it really fit in the categories...I
have a wonderful man from Winchester that is assisting me with this. He is
really good.

"pupkiss1965" <(E-Mail Removed)> wrote in message
news:0B8D6777-0A36-4E12-92FC-(E-Mail Removed)...
> Sorry about that...I wasn't sure where it really fit in the
> categories...I
> have a wonderful man from Winchester that is assisting me with this.
> He is
> really good.


No problem. Live and learn, as they say!

Yes, he is. I've learned a lot from reading his answers.

--
Clif
Still learning Access 2003