Re: I need combine 4 references in one Inline view

Magel · 04-30-2020 07:39 AM

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

Steve

Try:

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