Discussions
Display another item's information
I'm hoping someone has done this before or maybe has an idea how to. We'd like to be able to display information from another item on an item display template. Basically:
I have an item in Netsuite (item #1) with a custom field that contains the item name of a separate item (item #2). This is used to create a one-to-one relationship between these two similar items.
On item #1's item drilldown template, I am able to pull the information from this custom field to get item #2's item name.
How can I now query the database to pull some information from item #2's item record for display on this same drill template?