Lookup-Fields: Fetch Only needed


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.

Best regards,

What platform (Delphi, .Net, XCode) you are using?


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”


I’m using version and I wish to achieve the same function as mentioned but in .NET platform. Do you have example?

Please take a look at

topic “Eager Data Loading”