I need combine 4 references in one Inline view

Hi, I have 4 product fields in 1 row invoice each reference for table products.
I use Inline view and I whant to combine all 4 references tables in one Inline view.
I try to use :

  • REF_ROWS(“TTN”, (“Product1”,“Product2”,“Product3”,“Product4”))
  • REF_ROWS(“TTN”, (“Product1”),REF_ROWS(“TTN”, (“Product2”),REF_ROWS(“TTN”, (“Product3”),REF_ROWS(“TTN”, (“Product4”)
    but recieve reference only from Product1 field.
    UNIQUE(
    ( LIST
    (REF_ROWS(“TTN”, (“Product1”),
    REF_ROWS(“TTN”, (“Product2”),
    REF_ROWS(“TTN”, (“Product3”),
    REF_ROWS(“TTN”, (“Product4”) )) - show ID of rows but not table data

Try:

(
  REF_ROWS(“TTN”, “Product1”)
  + REF_ROWS(“TTN”, “Product2”)
  + REF_ROWS(“TTN”, “Product3”)
  + REF_ROWS(“TTN”, “Product4”)
)

See also:

2 Likes

Greate !!! Thanks

1 Like