Create a query from two tables that autofills column
I have retail stores with a database that tracks events from the locations.
I have two tables:
Table 1: houses all the events and the data associated (location, date, description, etc.)
Table 2: houses each location with the corresponding manager
I'd like to create a query that links the two tables. Basically it'd have all the same columns from Table 1, plus a managers column based on the info in Table 2. Hypothetically, the correct manager would populate based on the location. I just don't know how to actually link this.
Doing this would save me precious time, as there's thousands of entries in Table 1 and it'd take forever to manually add the manager to each entry.
Please help. Thanks