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,
A filter can be created automatically, but it doesn't depend on the data type. There must be a relation between TableA and TableB.
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.
André Arnaud de Cal...
292,074
Super User 2025 Season 1
Martin Dráb
230,900
Most Valuable Professional
nmaenpaa
101,156