487
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
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
Can you show us the design of your form please? What does the button do? What exactly do you mean by "sub form"?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (