View Single Post
Old 06-11-2019, 09:13 AM   #1
Newly Registered User
Join Date: Jun 2019
Posts: 18
Thanks: 5
Thanked 0 Times in 0 Posts
templeowls is on a distinguished road
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

templeowls is offline   Reply With Quote