Secondary Collections - Need help understanding how they work

I've got a Form I'm designing based off of SLItemLocs. The form has two parts. The top part shows the information about an Item depending on the Rank you pick. The bottom part contains a Grid that is supposed to show the other locations that the Item could be restocked from based on rules we define. Since this list is different than my Primary collection, I've added a Secondary Collection of SLItemLocs. I've added the Filter to the Collection itself under Selection -> Permanent Filter. When I load the form, the Grid doesn't populate at all. The previous incarnation was working when I had a sub-collections and used SLItemWhse, but after review it makes more sense to use SLItemLocs.

How do I get the Secondary Collection to load & display information in the Grid? I must be overlooking something simple.

Find more posts tagged with

General Discussions

Accepted answers

Stephen Cena

Ok it worked. This is a solution, but openly admit maybe not the best solution. Using 1362426 's suggestion for the Form Event to use, I've added a Form Script just before the Collection refresh that does this:

Sub SecondaryCollectionTest()

ThisForm.GetSecondaryIDOCollection(2).Filter = "(Item='" & ThisForm.Components("comboBoxItem").Value _

& "') AND (INSERT_LOCATION_LOGIC_CLAUSE_HERE)"

End Sub

The only side effect now (which I can live with) is the Grid displays 0's in a few fields if no records are present. Other than that, it works exactly how I want.

This may ultimately turn into a non-issue, as I think the client may not wish to see the data anymore but this was good to learn for future projects. Thank you to all you helped!

INFORD~1.MP4

All comments

unknown

Hi Steve,

Do you have a StdObjectSelectCurrentCompleted Event that refreshes the secondary collection so that the data in the grid will refresh when a record is selected in the primary grid?

Also, use "object" (primary grid) for the "Only When Current Collection Is" in the parms of the event.

Stephen Cena

That got me closer. The part I'm missing now is how to add the selected Item to the filter for the Grid. Right now, it's pulling back every location meeting my criteria for every Item when I only want it to do it for the current Item in my combobox.

unknown

Hmm, the combobox your referring to is from the primary collection correct? You might need to update a variable on the form with the currently selected property of the primary collection. Then use that variable in your secondary collection's permanent filter expression.

Stephen Cena

Correct. The combobox (highlighted) is in the Primary. I currently have it tied to the Primary Collection's Item. Should I trade it out for a Variable and then use Inheritance/Component Class to get the Items to load?

unknown

Have you tried just adding a Subcollection property to the extended IDO and then binding it to the Grid? I like this method better than adding a Secondary Collection to a form.

unknown

Many ways to do this. Your suggestion may work and it is worth a try. J's suggestion is good because you can do the linking/joining that you are looking for. Another suggestion is to leave the combo box as the property but set a data change event that sets the value of the property to a variable.

Stephen Cena

J: This is an Infor IDO, so it's not extended.

I'm going to try something I did earlier in my previous incarnation of the form & see if it works. If it does, I'll post.

Infor Customer Experience Update for M3 User Groups-20210113_160317-Meeting Recording.mp4

Stephen Cena

INFORD~1.MP4

Copyright © 2025 Infor. All rights reserved.