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.
Hello,
Please look at “Fetch” example. It can be helpful for you.
You can find it in the following folder:
XP: "C:\Documents and Settings\All Users\Documents\RemObjects Samples\Data Abstract for Delphi\Old"
Vista,Win7: “C:\Users\Public\Documents\RemObjects Samples\Data Abstract for Delphi\Old”