Help

Can't Access Values with Linked Table

657 1
cancel
Showing results for 
Search instead for 
Did you mean: 
M_M3
4 - Data Explorer
4 - Data Explorer

I am having a problem retrieving values when linking one table to another. I made a video showing the issue (as it is easier to show it then to explain it). Here is the link (please forgive the watermark): Airtable Question -- Linked Table with Selected Field.mp4 - Google Drive

Thanks and be well,

Moshe

1 Reply 1

Hi,

I understand your issue and why it’s not working, but i can’t realize your goal in common. What’s the purpose of Diameter table and why do you choose autonumber for primary field of Attributes?
In short, linked field connects one table to another table (not field), and when you set links (which connecting records to each other), you will see the “record name”, which is a value of primary field. So, when you connect Junction to Attributes, you see its records as a set of numbers(from autonumber). Of course, you can act from “other side” - go to the Attributes table, connect Diameters, copy-pasting diameter values column into that linked field, add lookup field (Junction links from Diameter table), copypaste them into linked field with Junction.
But for now, such base design looks a bit… “inconvenient”? If you are planning to add more links in future, searching from Juction table to diameters in Attribute, maybe you should make this column a primry field?