Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Add a datasource and r...

Add a datasource and relations at runtime to a view

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I have a form which uses a view as a datasource and I have to add tables to it at runtime. I am trying the following code which is failing could you please suggest what is going wrong?

//qbds.addDataSource(tableNum(InventTable)).addDynalink(fieldNum(ETExtractionView_SAM,ItemId),fieldNum(InventTable,itemid));
        qbds.addDataSource(tableNum(InventTable));
        qbds.addDynalink(fieldNum(ETExtractionView_SAM,ItemId), InventTable, fieldNum(InventTable, itemid));
        qbdsbrand = qbds.addDataSource(tableNum(BrandTable_SAM));
        qbdsbrand.relations(true);
        qbdsbrand.addRange(fieldNum(InventTable,Brand_SAM)).value(brand);

*This post is locked for comments

All responses (2)

Answers (0)

Rustem Galiamov 8,072 on at

Like (0)

Report

RE: Add a datasource and relations at runtime to a view

Hi Deepak88!

Can you provide the complete code? And what error did you get?

Does the InventTable contain Brand_SAM field?
Suggested answer

udaY-ch 4,624 on at

Like (0)

Report

RE: Add a datasource and relations at runtime to a view

Hi,

Try following the thread,

community.dynamics.com/.../157355

Best,

Uday.