Oct 28, 2020 09:20 AM
I have a table of Volunteers that lists their name, email, cell phone, etc. I also have a table called Teams. In my Teams table, I have a “TEAM LEADER” field. I’ve linked that field to the Volunteers Table. I am able to select a name from the Volunteers list just fine.
The next two columns are “Cell Phone #” and “Email Address”. I’ve tried making those two columns a Lookup on the “Team Leader” column. It seems like I’m able to do that fine, but it doesn’t automatically populate the email and cell phone # from the Volunteer table, which is what I thought it would do. ie. I thought when I select a person from the Volunteer table to be a Team Leader, it would automatically also pull that person’s email and cell into the next two columns.
Am I thinking about this all wrong?
Oct 28, 2020 10:10 AM
Yes, it should work like you expected it to work. Why don’t you post some screenshots of how you’ve setup your tables and fields, so we can see where it might be going wrong?
Oct 28, 2020 11:26 AM
Oct 28, 2020 09:12 PM
In the Team/Zone table, what do the field customizations look like for the Cell Phone # field & the Email field?
Oct 29, 2020 09:05 AM
Here you go. Thanks for your help.
Oct 29, 2020 09:32 AM
Notice that your Email Lookup field is pulling from a different linked record field called “Field 12”. It needs to pull from the same linked record field as the cell phone lookup, which is “Team Leader”.
Oct 29, 2020 09:49 AM
Yay! Ok. I think that was it. Thank you so much. Ironically, the answer came from “ScottWorld”. Can’t beat that.
Oct 29, 2020 10:25 AM
Haha, it was meant to be!