title: Use one table for multiple LookUp fields in Access
body: <p>I'm working on a responsibility chart in Access. Rows are projects and columns are project responsibilities. The cells will be populated with a staff member's name.</p>
  
  <p>I made a separate table with the staff members names and used the lookup wizard in the responsibility chart to take the values from the staff member table. After setting all the columns up with the Lookup Wizard I get the error of Too Many Indexes. Because each column is using the same information as its lookup source  is there a way to get around the limit or restructure my lookups in a way that works like how I intended. I have about 40+ project responsibilities/columns to tackle.</p>
  
  <p>My goal is to be able to add names to the staff member table and have them become selectable in all columns of the project responsibilities list.</p>
  
  <p>Thanks,</p>