This should be possible using the CCK nodereference field.
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 http://drupal.org/project/ubercart
On Mon, Dec 27, 2010 at 10:52 PM, pavithra m <pavspavi88@gmail.com> wrote:
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