Announcements
No record found.
I have a table whose field contains a No. of a Sales Order Record.
I want when a user clicks that , Sales Order Page of that Specific No. opens up.Please help me out ?
Set the TableRelation property of the Sales Order No. field to the Sales Header table (where Document Type = Order).
I've tried this,
this
and this
in the Last Screenshot the fields which Intellisense is showing are form current table not from "Sales Header" that's why i can't select "Document Type"::Order.What should i do now ?
Hi,
It should be like this:
TableRelation = "Sales Header"."No." where ("Document Type" = const(Order))
Best regards,
Krzysztof
Thanks You Very Much Krzysztof Bialowas & Stefano Demiliani for your kind help. But using this statement
Order is getting accessed only on card page
When i click on the primary key of this table on list page, the cards page gets open.
What i want is that On the List page when i click on the Sales Order No.The Sales Order Card Page of that No. gets open.
is there any way to do that?
The UI has a standard behaviour. The first field you mention as “clickable” it seems a flowfield. A field with a table relation instead opens the related record in a list and from here you can open the card.
If you want a different behavior, you should handle OnLookup event via code and from here retrieve the Sales Header record and open its card page.
I always suggest to use the standard UI behaviour because the entire system works in a consistent way and your page should be compliant to the UI standards.
I've Tried this
and getting this error
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to a top community star!
In our never-ending quest to help the Dynamics 365 Community members get answers faster …
Welcome to the next edition of the Community Platform Update. This is a status …
Stay up to date on forum activity by subscribing.
