P
pupkiss1965
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 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