How to Show Only Specific Columns in Child View

I have a Parent Table named Orders and Child Table named Stock Item. So one order can contain multiple Stock Items purchased by a Customer.

In the Orders View when we click on Related Stock Items Purchased it shows the details of the Stock Items purchased from the Child Table Stock Item. Now I want only a few Columns of the Child Table to be seen there. Like the Stock Item Name the Selling Price and I don’t want the Cost Price to be seen there.

Please let me know how I can do this.

Thank You!! :blush: :pray:

HI @Total_Solutions

I think you can do it this way:

  1. create a slice named “Child_Slice” and containing your specific columns.
  2. add a VC to your parent table, called “related ChildSpecific” with formula
    REF_ROWS(“Child_Slice”, “keyColumn_ChildTable”)
  3. un-tickShow option on the usual related column
  4. Tick Show option on the “related ChildSpecific”

Let us know if that works for you

3 Likes

Solved!! You Rock!! Thanks a Million!! God Bless You!! :blush: :pray:

2 Likes

You are welcome :slight_smile: