Zoom Accross to SAME table

[Flo Boj]

Hi !

We use C_Order for all kind of 

offers and orders (issottrx='Y').

Now from inside a completed order, you like to zoom 

to the related offer ( ie the offer you used with Quote Convert  to create the order)

I cant zoom to another entity of C_Order, even if I do

TableValidation SQL Where "C_Order_ID=1000005"

The Tablevalidation below gives me the correct C_Order_IDs, but 

the Window that opens is the identity window !

Question :  How to zoom from Sales Order to another Sales Order ?

 c_order_id in (
                          SELECT distinct(o.C_Order_ID) FROM C_Order o
                           WHERE o.C_Order_ID in (
                            case when (select ref_order_id from C_Order where C_Order_ID=@C_Order_ID@  )  is not null then
                                      (select ref_order_id from C_Order where C_Order_ID=@C_Order_ID@ )
                            end                              )        
                        )
OR
C_order_id in (

 select c_order_id from c_order where c_order_id in (select  distinct(c_order_id) from c_orderline where m_product_id in (    select m_product_id from c_orderline where C_Order_ID=@C_Order_ID@    ) AND c_order_id !=@C_Order_ID@)
 AND issotrx='Y'

)

Long time no see

Best Regards

Florian

[Flo Boj]

Problem Solved !!

Its been the Target Reference :*((

CU !