Notifications
Announcements
No record found.
Hi,
Greetings
I have a form below in Ax 2012
When the user clicks on the Add button to add the machine the below form(sub form) should filter automatically based on the part added
How can i filetr the grid?
Example
Can you show us the design of your form please? What does the button do? What exactly do you mean by "sub form"?
Is this in excel?
If happen on AX, maybe you need do customization for it.
If you have two tables and you always want the second table to be filtered, you can define a relationship between the two tables. In this case, since there will be a header/line relationship between the two tables/grids (depending on the join in the form datasource as well), you will only see the line records of the header you are on.
As you said in your question, if you want it to be filtered only when you press the add button, you should apply range to the second table. If you search "AddRange" on AOT/Forms, you will find many examples
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional
