View Single Post
Old 06-11-2019, 09:42 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,088
Thanks: 36
Thanked 735 Times in 718 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Create a query from two tables that autofills column

Hi. Welcome to the forum. I hope you're not trying to store/copy the manager info to the location table. If you're only trying to produce a combined data for a report or a mailing campaign, you can use a query to do that. For example, in the query designer, you can add both tables and then link them using the LocationID (or whatever is the primary key for the location table). You can then drag all the fields from Table 1 and only the Manager data from Table 2 on to the design grid. When you run the query, it should show all the assigned managers for each location.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
templeowls (06-13-2019)