It would be much better if we could also define directly in the property of the field that only desired or required fields are displayed when we create a TableRelation in the property of the field.

Currently it is possible to set filters on TableRelation to show some field data if the condition matches, which is very good, but unfortunately we don't have the option to show only the required fields.

It would be very nice if Microsoft would add this feature in the next version of Dynamics 365 Business Central.

In the obove pasted code example filed with TableRelation = Vendor; it show all the Table-fields which are not required.

I want only to show "Vendor No." and "Name".

field(1; "Vendor No."; Code[20])

{

  Caption = 'Vendor No.';

TableRelation = Vendor;

}

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Suggestion:

To show the required Table-fields:

It could be for example like this below:

-------------------------------------------------------------

field(1; "Vendor No."; Code[20])

{

  Caption = 'Vendor No.';

TableRelation = Vendor ShowFields("Vendor No.", Name, ...);

}

If we don't mentioned explicity to reduce or to show some desired Table-fields, then it should shows all the Table-fields.

Thank you very much!

Sincerely

Shuja