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

Custom column assign for table relation

(0) Share

Report

Posted on by jyoon0619

Hi I have a question regarding assigning column for the table relation.

First of all, I have a custom Table and page where you can set manufacturer, manufacturer brand, and implant size.

Table ManufacturerTable

page ManufacturerPage

I have 3 fields in item card where I want to have each field have table relation with ManufacturerTable

Purpose of doing this is I want to have custom selection where first Manufacturer is selected than show filtered list of Manufacturer Brand which matches to selected manufacturer and when Manufacturer Brand is selected, filter Implant size.

Thank you for your time to read my question.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Andy Sather on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

A table relation can include a where clause. You can use it to filter with another field of the source table or another table. This one is used in the sales line table:

TableRelation = "Sales Header"."No." WHERE("Document Type" = FIELD("Document Type"));

Can be done for multiple fields

Was this reply helpful? Yes No
YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (0)

Report

Hi, although it is not exactly the same, I think you can refer to the Account No. field in the table 81 "Gen. Journal Line".

Was this reply helpful? Yes No