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!!

Solved Solved
0 3 237
  • UX
1 ACCEPTED SOLUTION

Aurelien
Participant V

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

View solution in original post

3 REPLIES 3

Aurelien
Participant V

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

Solved!! You Rock!! Thanks a Million!! God Bless You!!

You are welcome

Top Labels in this Space