Ever wonder what the selected column (Ref. Filter) in the image represents? I would request you to go through my previous blog ‘Understanding Cascading’ so that you understand this topic easily. If you already have, lets go ahead… Well, this column provides you with an option to enable ‘Filter by Reference’ for a syncBo. If you look closely at the image you will observe that this option is not available for all the syncBos but for only syncBos who have one or more child syncBos. Yes, you are right…MAM25_006 does not have any child syncBos and hence you are prevented from enabling this option in it while with MAM25_016 you can. Not only this, but there should be atleast one cascade relationships between the parent syncBo and the child syncBos. So, what is the use of this ‘Filter by Reference’ (FBR)? We will try to understand the usability in two ways, functionally and technically, with an example. Let us consider a relationship ORDER -> FUNCTIONAL LOCATION. Any assignment to be executed in a Functional Location is given to a user in form of an Order. In other words, whenever a user has to carry an operation at a particular Functional Location, then an Order will be deployed to his device. Now, what if the user does not have any Order for the Functional Location. In such a case there is no point keeping the Functional Location’s information on his device as it is useless for him. You can ensure this by enabling FBR for the Functional Location syncBo. Technically, how does this help? Practically, at given point of time, there are very few Functional Locations which will be having any orders. Putting all the Functional Locations’ information on the device will not only consume lot of memory on our PDA but also slow it down considerably. FBR helps us with wise use of our resources. How does FBR work? On sync of the parent syncBo, only modified or deleted records from will get downloaded. On sync of the child syncBo, the newly created records of the parent syncBo alongwith the associated records of the child syncBo will get downloaded. Hope what the ‘selected column’ does is now clear to you.