This should be possible using the CCK nodereference field.<div><br></div><div>From the description of your problem, however, it seems you are trying to build a store. If that is the case, consider using an e-commerce suite such as <a href="http://drupal.org/project/ubercart">http://drupal.org/project/ubercart</a><br>

<br><br><div class="gmail_quote">On Mon, Dec 27, 2010 at 10:52 PM, pavithra m <span dir="ltr">&lt;<a href="mailto:pavspavi88@gmail.com">pavspavi88@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Let me explain the structure I want.<div><br></div><div>I have the content type PRODUCT which has cck fields ProductCode and ProductName.</div><div>I have 2nd content type ORDERS with feilds Quantity.</div><div><br></div>
<div>
When I create nodes of type ORDERS, i want the product code to be present in the ORDERS node and when I click on to it, it has to show me the node created with that product code of type PRODUCT.</div><div><br></div><div>
<br>
</div><div>Eg:</div><div>PRODUCT node 1stNode is created with product code P001 and productname AMLA</div><div>I create ORDERS node 1stOrder,with quantity. This node should have P001 displayed which will link to the node 1stNode when clicked</div>

</blockquote></div><br></div>