Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Filtering data between forms

(0) ShareShare
ReportReport
Posted on by

Hi guys,

I have a FormA that the table consist of TableA with Index FieldA, I display the contain in a grid. And then I create another Form, which is FormB consist of TableB with index of FieldB, but this FieldA and FieldB is using the same EDT.

In FormA, while displaying TableA in the grid, at the Top panel, added a Display Menu Item with referring to FormB. In that Display Menu Item, I put its property: DataSource to TableA. 

Question is : will there be a connection so that the data displayed in TableB in that FormB "automatically" filtered based for the value of FieldA from TableA ? basically both field using same EDT and the value is using the same main table.

Or  I still need to manually filtered in FormB -> initial query ?

I happened to experience some form auto filtered, but I cannot recall what is the setting or condition ?

Thanks,

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,900 Most Valuable Professional on at
    RE: Filtering data between forms

    A filter can be created automatically, but it doesn't depend on the data type. There must be a relation between TableA and TableB.

  • Verified answer
    GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Filtering data between forms

    Hi Voltes Dev,

    If there is a relation between Table A and Table B then the Ax will automatically filter the Form B based on Form A.

    In most of the cases relation is enough if not then you need to add code to filter records.

    Thanks,

    Girish S.

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,074 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,900 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans