# In short, what I would like to achieve is a filtered/grouped selection when creating a new record in a table that is linked to a table which itself is linked to another table.
**URL:** https://community.baserow.io/t/in-short-what-i-would-like-to-achieve-is-a-filtered-grouped-selection-when-creating-a-new-record-in-a-table-that-is-linked-to-a-table-which-itself-is-linked-to-another-table/9871
**Category:** Baserow Help
**Created:** [April 4, 2025, 1:06pm UTC](https://community.baserow.io/t/in-short-what-i-would-like-to-achieve-is-a-filtered-grouped-selection-when-creating-a-new-record-in-a-table-that-is-linked-to-a-table-which-itself-is-linked-to-another-table/9871 "2025-04-04T13:06:06Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@mirwit](https://community.baserow.io/u/mirwit)
#### Post date: [April 4, 2025, 1:06pm UTC](https://community.baserow.io/t/in-short-what-i-would-like-to-achieve-is-a-filtered-grouped-selection-when-creating-a-new-record-in-a-table-that-is-linked-to-a-table-which-itself-is-linked-to-another-table/9871/1 "2025-04-04T13:06:06Z")
### Are you using our SaaS platform ([Baserow.io](http://Baserow.io)) or self-hosting Baserow?
SaaS
### What do you need help with?
Hey, I just started using Baserow and am struggling to figure out some basic things, which might also be because I am generally new to the topic of databases and co.
What I have are tables “cluster” and “topic”, where each topic is assigned one cluster. Now I have a table “solution”, where each solution is linked to one or more topics. Is there a way to make the selection of those topics visually grouped by clusters?
A picture for reference is attached. I would be interested in knowing how this is done in either form or grid view or both 🙂
Thanks a lot for the help already!
### Please attach screenshots or videos if they help illustrate your question.
---
### Author:  [@cwinhall](https://community.baserow.io/u/cwinhall)
#### Post date: [April 7, 2025, 12:37pm UTC](https://community.baserow.io/t/in-short-what-i-would-like-to-achieve-is-a-filtered-grouped-selection-when-creating-a-new-record-in-a-table-that-is-linked-to-a-table-which-itself-is-linked-to-another-table/9871/2 "2025-04-07T12:37:00Z")
Hi @mirwit, welcome to the community!
From what I understand, you would need to create a lookup field of the topic linked field in your solutions table. Then you would need to create a formula field to turn the values of those lookups into text so that you can then group by those results. The formula you would use is something liek this: `join(lookup('Topic','Cluster'),', ')`
Here are some screenshots of how I set it up:
Cluster Table
Topics Table
Solutions Table
---
### Author:  [@mirwit](https://community.baserow.io/u/mirwit)
#### Post date: [April 7, 2025, 2:56pm UTC](https://community.baserow.io/t/in-short-what-i-would-like-to-achieve-is-a-filtered-grouped-selection-when-creating-a-new-record-in-a-table-that-is-linked-to-a-table-which-itself-is-linked-to-another-table/9871/3 "2025-04-07T14:56:10Z")
Thanks a lot @cwinhall for the detailed reply, much appreciated! This is half of what I wanted, unfortunately the half I already have haha Sorry if my explanation was bad. Basically I have a setup that is as you re-created it here. But I would want a form/app that allows me to select from grouped records in a way we can group them in the data view. The record selector element is close enough but doesn’t allow grouping from what I have understood so far.