Verified answer

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).