I have 2 tables.
Frist contains all the values (over 120000) which i'm using later in the second table.
I have succesfully created a 3-lvl drill down setup so i can somehow navigate this.
The problem is – it is not a reliable way to find values as user needs to memorize where are those values.
I'd prefer to search for the values.
I've seen a method with a web viewer where one could even search for the value name like in a regular search field (not just auto-completing values). I implemented that and it works but it's still very slow.
I noticed that portals are super fast in viewing, what it seems, any amount of records.
Is it possible to use a portal to search and enter a value?