Subcollection filtering Primary collection

Legacy Contributor

Is there a way to filter a primary collection with a field in the subcollection? So let's say you have a form with a subcollection grid on it. When it is in filter-in-place mode is there a way you can enter a value in the subcollection grid and it would affect the results of the primary collection?

Thanks!

Legacy Contributor

Yes, I believe one way is to fire a form script event when you want to filter (say on filter in place completed event handler). In that event event handler add a new event with priority 2 (so its called after filter in place is completed) . In that script get the row value via component of grid and then filter the primary collection , Something like this:

ThisForm.PrimaryIDOCollection.Filter =" 'ColumnNameForFilteration "+ ThisForm.Components("FormSecondCollectionGrid").GetGridValue + " ' "

and then refresh your collection
ThisForm.PrimaryIDOCollection.Refresh()

 

Hope this Helps !