Microsoft Access question on Look up columns...?

Question

I'm creating a Microsoft Access contact database and have certain contacts who are members of multiple committees- some of those members may be the chair of one committee (ie Joe sits on Labor, finance and rules but is only chair for labor) is it possible to create a look up column whereby I can click on multiple committees and link which one the person is a chair on?

Answer 1

This is really too much to try an answer, but the answer is yes. But if one person can be chair of more than one committee, that changes things greatly. I would instead, have one table which lists all the people (your contact table), including name, phone, address, and then have a table for each committee (Labor_tbl, Finance_tbl, Rules_tbl). In each of these committee tables, you link to the contact table by a unique id (could be as simple as Joe is id 1, Sage is id 2, etc...). Also in each committee table you have a field that lists their role (Chair, treasurer, secretary), or "Chair" could be a column with yes or no. If instead you insist on a lookup in the contact table, then you need to just find an Access sample table that has some dropdowns. View that table in design view and click on one of the fields that has a dropdown. Click on the lookup tab and you'll see "Row Source" column with a list of items that show up in the drop down. Follow that example (the other columns are important too).