I wanted to know if there was a way to pull data and display them together from multiple tables.
Here’s an example:
Table 1 Columns: (Computer, Model Year):
Mac | 2015
PC | 2017
Table 2 Columns: (User, Computer - formatted as "Lookup from Table 1):
Bob | Mac
Larry | PC
Is there a way to display, in table 2, the “Model Year” column automatically once I select “Computer” in a 3rd column?
I want table 2 to look like this, with the following columns: User (select from list), Computer (Lookup from Table 1), Model Year (automatically populate from Table 1):
Bob | Mac | 2015
Larry | PC | 2017
Thanks in advance. I’m learning more and more every day from this community!