Lookup columns that allows to search values within other tables

Is your feature request related to a problem? Please describe.

No response

Describe the solution you'd like

In order to build solid applications, we need to create relations between tables, but currently all we can do is create a link to a tables.

Here are a few scenarios that might help you understand my request :

Scenario #1 : I create a table "Categories" in which I have only one text column called "Title" in which I enter the title of all the categories. I create a second table "Subcategories" in which I have two columns, one is a text column called "Title" in which I enter the title of the subcategory and the second column would need to be a lookup column that I would point on the values of the title column of the table "Categories". This would allow me to link the subcategory to the matching category.

Scenario #2 : Using the tables created in scenario #1, I create another tables called products, In which I have four columns. The first column is a text column called "Product name" in which I enter the name of the product. The second column is of type number with suffix $ called "Price" in which I enter the price of the product. The third would need to be a lookup column that I would point on the values of the title column of the table "Categories" to allow me to associate the product to a category. The fourth colum would need to be of type filtered lookup that I would point on the values of the title column of the table "subcategories" but filtered by the category selected in the third column.

That kind of feature is available in many cloud solutions offered on the market (AWS, SharePoint, Dataverse, etc.) but this solution doesn't have it and it represent a blocking point for my business to move forward with your solution. Once you have that option in your solution, I'll be able to fully get rid of any Microsoft cloud solution.

I hope you'll consider that request

Describe alternatives you've considered

Currently there is no other alternatives in NextCloud which is why we are forced to keep active Microsoft accounts to host our tables data. Lookup columns are essentials in any data tables solution.

Additional context

No response

The request describes lookup columns across Categories, Subcategories, and Products, including filtering subcategories by category. Start by locating the existing table and column-type entry points, then determine how relations and filtered values are represented. Done should include cross-table lookup and filtered lookup behavior matching the scenarios, with documented acceptance criteria and tests.