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

TableRelation Use

(0) Share

Report

Posted on by ChrisG123

Hi all,

I am wondering if I am using the table relation property correctly in a tableextension. Screenshot below:

I am trying to get these fields to display exactly the same information as the field the table relation is pulling in for each one. For example, I want "RunTimeHTC2" to pull in the same data as "Prod. Order Routing Line"."Run Time".

Please let me know if I need to include any 'where' clause or 'if' statement to make a table relation work.

Thanks,

Chris

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Brad_P 1,549 on at

Like (0)

Report

If you're trying to display the value from a related table you would need to use a FlowField. The TableRelation will indicate the table and field value for the field (think of lookup)

Was this reply helpful? Yes No
ChrisG123 35 on at

Like (0)

Report

Brad, could you show me how to put that into the table extension above?

Thanks,

Chris

Was this reply helpful? Yes No
Suggested answer

Brad_P 1,549 on at

Like (0)

Report

You might be well served to become familiar with MS Learn - learn.microsoft.com/.../devenv-flowfields

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

As Brad says. Flowfield is the way to go in your case.

Table relations are used to control that the values in the field only will be valid if they meet the table relation definition.

Was this reply helpful? Yes No
Suggested answer

Shathika Karunaratne on at

Like (1)

Report

Hi Chris,

Please do use a FlowField type field to fulfill your requirement. I have attached a Snap of Debit Amount in Customer Ledger Entry Table

\

FlowFields - Dynamics NAV | Microsoft Learn

Thanks

Please do verify if this helps you

Was this reply helpful? Yes No