Hey guys, here's what I'm trying to do:
I'm using Drupal basically as a inventory database and I have 2 content types: "Manufacturer" and "Products"
"Manufacturer" is basically a 1-field table that contains a mass list of hardware manufacturers. I have a page view so I can add/edit/delete these at any time.
The other content type is "Products", which has many fields, such as product name, description, price, etc.
Now, I want to add a drop-down field to "Products" which, when clicked, lists the entire manufacturers that I currently have on manufacturers content. So the person can just pick it from this drop-down instead of typing the manufacturer name manually on a text field.
I'd greatly appreciate if you could tell me the modules I need to install and briefly describe what I should be doing. Thanks in advance!