Let me explain the structure I want. I have the content type PRODUCT which has cck fields ProductCode and ProductName. I have 2nd content type ORDERS with feilds Quantity.
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. Eg: PRODUCT node 1stNode is created with product code P001 and productname AMLA I create ORDERS node 1stOrder,with quantity. This node should have P001 displayed which will link to the node 1stNode when clicked
