Linking and Lookups

[Scott_Witzig]

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?

Scott

[ScottWorld]

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?

[Scott_Witzig]

[ScottWorld]

In the Team/Zone table, what do the field customizations look like for the Cell Phone # field & the Email field?

[Scott_Witzig]

Here you go. Thanks for your help.

Scott

[ScottWorld]

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”.

[Scott_Witzig]

Yay! Ok. I think that was it. Thank you so much. Ironically, the answer came from “ScottWorld”. Can’t beat that.

Scott

[ScottWorld]

Haha, it was meant to be!