Dynamic filter for Parent/Child relationships

[Ash_Nazarizadeh]

As far as I know, currently it’s not possible to create a parent/child style application in AirTable. A dynamic filter that could filter records in one table based on the current record in another related table would help tremendously.

Example:

Table: “Projects” (Parent)
Field: “Project ID”
Values: 1,2,3,4 (4 different records)

Table: “Resources” (Parent)
Field: “Resource ID”
Values: 1,2,3,4,5 (5 different records)

Table: “Project Resources” (Child of “Projects” and “Resources”)
“Project ID” , “Resource ID”
1, 1
1, 2
1, 3
1, 4
2, 1
2, 5
3, 1
3, 2
3, 5

Currently the filter in “Project Resources” would have to be hard-coded:
Project ID = 1 (hard-coded) to show only the resources with Project ID of 1.

Filter: Project ID = 1
“Project ID”, “Resource ID”
1, 1
1, 2
1, 3
1, 4

However, the below filter would help establish a Parent/Child Relationship dynamically:

Filter: Project ID = {Projects}.Key (or the “current row value” of any field in the “Projects” table.

Where:

• “Project ID” is a field in table “Projects Resources” linking “Projects Resources” table to “Projects” table (a foreign key).
• {Projects} is the table “Projects”
• Key is the value of the “current row” of a field called “Key” in the “Projects” table.

This would allow you to see only the “Resource ID” records that are associated with the “Current Project”. So, as you traverse the records in the “Projects” tab/table, you would only see associated resources in the “Project Resources” tab/table when you switch to that tab.

[Ash_Nazarizadeh]

BTW, thanks W_Vann_Hall!