I have a table comprising a list of file paths for images and an associated identity. Images for the same item share the same identity. I have loaded the entire data into the BO to save on accesses to the database. My intention is to get a subset of the data using the associated identity, but I'm not sure how to achieve this. Can anyone point me in the right direction.

Many thanks in advance.

Thanks for explain.



Yes the BO.Filter will give you what you want, just need to use it carefully because the filter will affect the BO.CurrentView and BO index, so the bo.Count will reflect the records shown in in the CurrentView which may be filtered or not.



There are plenty of samples on how to use the filter here in the forums and also in the help file.



Basically you add the filter like: bo.Filter = "MyFieldName=" & FieldValue, then to reset the filter just set it to blank space bo.Filter = ""



Hope this help.

Edhy Rijo

Many thanks for that pointer, it helped a great deal.