Help

Links to other records / can't repeat the obvious!

Topic Labels: Base design
532 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Kevin_Ford
4 - Data Explorer
4 - Data Explorer

Hello,

I’m an Airtable noob and have worked through the tutorials and have started building a database made up of 3 tables, Area, Compound and Assets and Structures.

I have managed to make compounds link to the Area table, i.e. the parent, and Assets and Structures to the Compound table, their parent.

I can’t seem to link the Assets and Structures to the Area ultimate parent table, which shows the headline information; think linear infrastructure project.

Whenever I add a link, it always ends up with two fields being added, where I only ended up with the single field for the Area/Compound and Compound/Asset relationship.

I know I’m doing something obviously wrong, but I’m burning a lot of time going round in circles and need to add other tables which need to link through at respective levels back to the main Area table.

AAAAAAARRRRRRGGGGGHHHHHH!!!
Area to Compound link working:

image

Compound to Area (CFA) and Asset working:
image

Asset to Compounds working:
image

Assets to Area (main table) not working!! :grimacing: and showing two fields (columns) when I only want the one!!
image

Thanks for your help. Frustrated in Kent!

0 Replies 0