Small and medium business | Business Central, N...

Table relations on the fields of request page of report based on the request filter fields

(0) Share

Report

Posted on by M Hussnain Javed

241

I added 5 fields on the request page (Quote 1, Quote 2, Quote 3, Quote 4, Quote 5) having follownig relationship:
TableRelation = "Purchase Header"."No." where("Document Type" = const(Quote));
In this way, all the quotes are shown in the drop down list.

I then also added two request filter fields. These are:
RequestFilterFields = Type, "No.";

"Purchase Header"."No." is a document no which is present in the table "Purchase Header" and RequestFilterfields Type and No. are present in the sub table "Purchase Line". So here I've two tables.

In the above attachement all the purchase quotations are shown in the drop down list. As different purchase quotations have different items so for instance, if I select Type = Item and No. = 1000 then in the drop down list only those quotes should be shown which have this specific item No.

I'm using BC Version 15.0. Anyone who can guide me if it is possible or not? If yes, then how can I add this functionality on the request page? Thanks for reading.

All responses (2)

Answers (0)

Suggested answer

Rbansode 5 on at

Like (0)

Report

RE: Table relations on the fields of request page of report based on the request filter fields

I think instead of doing it via a Lookup field, you would be better off doing it via a drill down as there is more control over the records that can be selected.
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Table relations on the fields of request page of report based on the request filter fields

Hello,

We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

I will open this up to the community in case they have something to add.

Thanks.