Writing a Query!

[dsaxena15]

Hey guys!



I have a Committee Table and a Faculty table. The Committee table imports the faculty ids for each of the five members of a committee.
What I'm trying to do is write a query so that it would display the last names of the faculty members for each committeeID.

The first image is the design view in Query design for these two tables. The second image is committee id followed by the faculty ids and I would like to see the ids replaced by lastnames.

[pbaldy]

You would add the Faculty table to the query 5 times. Access will give 4 of them aliases like Faculty_1 which you can change to something more meaningful. Then join each of your fields to a different copy.

If it seems difficult, it's because the design is not normalized, which would be a related table with a record for each person.