2 Replies Latest reply: Aug 6, 2013 2:34 PM by Marc Livingston RSS

    Not Exists issue, create new rows in a table

      I have a document where I am loading 2 QVD'S Quote and Quotedtl.

       

      The Quotedtl is set to a left keep.

       

      Now due to some complicated table structures and linking I have come across an issue. Currently a record can exist in the Quote QVD where there are no existing lines. As I said to due linking going through the Quotedtl table to get to the Quote table, I loose all of these records.

       

      What I need is in addition to the above qvds, I need to load a "Blank record" into the line table when there is a quote record but no lines.

       

      Linking between the 2 tables is done via company & '-' & quotenum

       

       

      Anyone have ideas? I tried creating a Not Exists where clause on a resident loaded Quote but this returned no records.