Filtering data between forms

(0) Share

Report

Posted on by VoltesDev

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,

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

GirishS 27,843 Moderator on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 239,178 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No