Skip to Content
0
Former Member
Feb 27, 2009 at 02:52 PM

Copy CardName into Quotation line by using formatted search

142 Views

I'm looking for the right query to copy the CardName from the OCRD table into a quotation line (QUT1) by using a formatted search. The UDF field in the QUT1 is U_Levnaam. In the field U_Levnaam I want to place the formatted search with the query.

I don't no if this is possible, because the field CardName of the OCRD table doesn't have a direct link to the QUT1 table. There is a link between the OCRD and OITM table.

This is how far I came. I have tried other solutions as well but without any result. Probably is has to be a complete other query

+SELECT T0.CardName FROM OCRD T0 INNER JOIN OITM T1 ON T0.CardCode = T1.CardCode Where T0.CardCode = $[OITM.ItemCode]+

So if anyone has a solution your help will be very appreciated.

Regards,

Tim