how to look for a specific item with a query?

[Guest]

im creating a database for my business class.
Of companies and thier board of directors. And i have very
little expierience with Access.I would really appreciate it
if someone could help me out with this. Is there a way
i could search for say a specific company and get all
of the people in its board of directors or vice versa?

Thanks alot.

 

[Al Camp]

Noobie,
This is a very broad question, and a bit too general for a concise
answer.
Basically though...
1. You would create a table to hold all Company information.
(ex.tblCompanies) Each record would have a unique key identifier, such as a
CompanyID. Enter the company info into that table (CompanyID, CompanyName,
CompanyAddress, etc..)
2. You would create a table of CEOs (ex tblCEOs) with all the
individuals being tracked. Each CEO would have a unique identifier like
CEOID. Enter all the CEO information into that table. (CEOID, Name, Age,
Address, Phone, etc...) This table represents the ONE side of a
relationship... "one CEO to many companies" he may belong to.
3. You would then create a table called tblCEOAffiliation that will
hold the CEOID and the CompanyID. This table represents the MANY in the ONE
CEO to MANY Companies. Right now, this table contains no info.
4. Create a Relationship between tblCEOs and tblCEOAffiliation. They
will be related via the CEOID in a One to Many relationship with Referential
Integrity and Cascading Update/Deletes.
5. Now, create a form with tblCEOs as the RecordSource. On that form,
create a subform with tblCEOAffiliation as the RecordSource. Link them
Parent to Child via the CEOID field.
For each CEO, you would enter... in the associated subform... a
CompanyID for each company thay are associated with. Because of the
relationship bewteen the two tables, each Company entry will automatically
be assigned the CEOID of CEO on the main form.

Now you could produce a query or a report that lists all CEOs, and the
company/companies they are associated with.

It's really up to you now... to learn about table design, creating
relationships, designing forms and subforms, etc...

 

[Al Camp]

Noobie,
I guess I got a bit carried away on that first post. If you've already
built your database, then we'll need to know the details of your tables and
realtionships before we can describe how to list CEOs to Companies, or
Companies to CEOs.
If you haven't built it yet... then my suggestion would be a waorkable
guide to doing so.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Guest]

sorry i was a bit broad on the topic. I had build the database but i was just
tinkering with it to see how it could work and what i needed it to do.
I appreciate your response and il post any other questions I have later on.
thanks