Filtering form based on multiple records from calling class

Hi guys,

How do you open a form that is filtered based on multiple records from the calling class?

For example, I have a table ItemCategory that has an itemid field. It then has a many-to-many relationship with the inventtable (one item can belong to many categories and one category can have many items).

I have a class wherein I need to get items belonging to one category and then open up the inventtable form such that when the form opens, it is already filtered showing only those matching items.

I saw this solution :…/

Is there another way or better way of doing it? My problem with the solution above is that you have to specify the items explicitly in the query range. I am looking for something automatic, if any, like specifying that it is just really an inner join between a table result of the calling class and the inventtable?

Sorry… i posted under the wrong group… supposedly for AX… pls ignore… can’t find a link to delete it…