Reference field or formula to display 'child' records in 'parent' table

Ask for Help
1

I have a ‘child’ table (pubs) where multiple records reference single records in a ‘parent’ table (towns). I want to have a field in the parent table listing related children. I have gone through the reference fields documentation and several templates, and cannot find how to do it, so I am guessing it requires a formula field of some sort?

I am a recent convert to Grist from Airtable, and liking it a lot - no plan to revert. But in Airtable you get what I want just by creating a Link field in the parent table to the child table.

cheers

Chris

2

You should look at lookupRecords. In your case, I guess a formula column with type Reference List and the following formula should do the trick:

Children.lookupRecords(town=$id)
3

Brilliant! Works perfectly. Many thanks.

Chris