Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
How to create parent, child relationship for cases
I dont think this is available as a standard option in NetSuite. I am trying to create a work around for this.
This is what I came up with, but I dont have enought SQL knowledge to figure this out.
I am trying to create the 'subsidiary of' relationship using custom fields as a workaround.
Create a custom field 'parent case:' of type list/record >> cases.
Create another custom field 'child cases:'
You can see the parent on all the children if you do this. But how do you automatically set a default value on the 'child cases:' field to source the case numbers of all cases that have current case # equal to 'parent case' #.
0