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