Skip to main content
Solved

Link Tables and Lookup fields

  • November 22, 2023
  • 2 replies
  • 36 views

Forum|alt.badge.img+4
  • New Participant
  • 1 reply

Hi

I have some linked tables. The first link is between "People" and "Working Groups". When in the Working Group table I can look up people's names and add them to the field "Members". When in the People table, I can make a link back to Working Groups, and a field called working groups will self populate with all the Working Groups that people are members off. This is all working fine.

I have a second link between "People" and "Training". When in the Training table I can look up people's names and add them to the field "Attendees". When in the People table, I can make a link back to Training, but I can't make a field that will self populate with all the training people have received. What am I doing wrong?

The only difference in layout between Working Groups and Training, is that training's unique identifier is a date.

Any light you could shed would be very helpful.

Thanks,

Davva

Best answer by ScottWorld

You actually don’t want to create any reverse linked record fields, because Airtable automatically creates those “backlink fields” for you. If you don’t see the field that Airtable created for you, then it is hidden under the “hidden fields” button in the toolbar.

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • Answer
  • November 22, 2023

You actually don’t want to create any reverse linked record fields, because Airtable automatically creates those “backlink fields” for you. If you don’t see the field that Airtable created for you, then it is hidden under the “hidden fields” button in the toolbar.


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 1 reply
  • November 22, 2023

Thanks Scott
That worked perfectly!