Microsoft Dynamics AX (Archived)

Selected record on list page displayed on the detail form

(0) Share

Report

Posted on by Community Member

How to get the selected record on list page, details on the detail form ?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report

Hi,

Can you provide some more details regarding your requirement. Record can be accessed through the formdatasource and you can use following code to loop through the selected records on form.

LocalTablename localTablename; // Declare table variable

Tablename_ds = _salesLine.dataSource();

for (localTablename = Tablename_ds.getFirst(true) ? Tablename.getFirst(true) : Tablename_ds.cursor();

localTablename;

localTablename = Tablename.getNext())

{

//Do your thing

}

Was this reply helpful? Yes No
krishna.rao@dax 3,006 on at

Like (0)

Report

you need to link the details form in listpage.

You could find same in standard forms such as salesorder,purchaseorder listpages.

If the requirement is not similar, express more..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I have a list page and a normal form

List page displays data of table A and the other form displays data of table B

both the tables are related through a common field

when I double click the grid of list page the other form opens but it shows all the data in the table B

I want to filter the detail to be shown of that record which is double clicked on the list page

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Hi,

Please try the following statements:

1. Set property CopyCallerQuery to Yes and NeedsRecord to Yes on the first listpage(FormA) MenuItembutton properties.

2. On FormB,
In the ClassDeclaration method declare common variable

Common callerRecord; TableA tableA;

In the init method, capture caller record

if (element.args().parm() == formStr(CaseDetail)) { custTable_ds.allowEdit(false); }
tableA = TableA::findRecId(callerRecord.RecId); // or write a query based on recordId

In the init method of tableB formdatasource

querybuilddatasourc qbds; Querybuildrange qbr; super(); qbds = this.query().datasourceTable(tablenum(TableB)); qbr = SySquery::findorCreateRange(qbds, fieldnum(TableB, commanField)); qbr.value(queryvalue(tableA.CommonField));

Was this reply helpful? Yes No