is there any way to fetch only the needed rows from a Look-Up-Table?
I’ve got three tables:
Table A - Master
Table B - Details (containing LookUp-Fields to Table C)
Table C - LookUp-Table
Table C is a rather big table and for most of the time it isn’t needed to choose another value in Table B - so there is no need to load the entire Table C.
However for displaying/interacting I need the rows in Table C which are referred from Table B.