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