Working with Access 2013 RRS feed

  • Question

  • My question is basic. I am creating a database that will help me to create all the reports required by my employer. My question is this. How can I create a lookup relationship that allows me to: Look up and select a value in one field and then based on that selection will auto-populate the next field.

    Example: Selecting a state in field A will auto populate field B with the account managers name that is associated with that state.

    I created the base table and exported a MS excel sheet that included all the account managers by state. The wizard created a query table, based on those relationships. When I go to create the account managers Field I select lookup and relationship as the field type, then base it on the query table. When I move to the last step and go to test the field I get a list of the account managers listed over and over again just as they appear in the original list, I am new to this please help or point me in the right direction.

    Thank you

    Thursday, May 1, 2014 12:52 PM


  • Michael,

    This is a CRM forum. For Office related queries you can post at http://answers.microsoft.com/en-us/office/forum/access or http://social.technet.microsoft.com/Forums/office/en-us/home?category=officeitpro

    If my response helps you in finding your answer then please click 'Mark as Answer' and 'Vote as Helpful'

    Thursday, May 1, 2014 1:19 PM