File this one under the "I almost put a fist through my monitor" section. :h_a_w: Just fought with this one for a couple of hours, but finally figured it out- and I wanted to post here so that it might help someone else avoid a mind numbing, rage inducing Tuesday morning
I recently created a new custom Record with a bunch of fields, one of which relates it back to a Customer Record. For a while, I was considering making that Customer a Parent of the custom Record, and I wanted it to appear on a Subtab. So I created the custom Subtab and, created a List/Record field, checked the "Record is Parent" box and selected my custom Subtab under the "Parent Subtab" drop down.
Hooray, everything works.
Later I decided this was not such a great idea, so I uncheck the "Record is Parent" box. The "Parent Subtab" drop down disappears. Happy happy, joy joy, all is well.
Afterwards I went through several iterations of other approaches to this particular business case, including using the same custom Subtab to display a sublist, blah blah blah. Bottom line, at the end of the day, we decide we don't need the custom Subtab at all. "Fine," I thought, "I'll just delete it."
NOT SO FAST. Apparently I failed to pay my tributes to the NetSuite gods. Every attempt to delete the custom Subtab resulted in ye olde "This record cannot be deleted, because it is referred to by other records" Error. Great. Care to tell me WHICH other records, NetSuite? Apparently not (unless there is a way to do this I don't know about??).
Search as I might, I could not figure out what this Subtab was connected to. It seemed as if I had broken any relationships it had. Finally I remembered vaguely that I had originally created this Subtab to display my new custom Record as a child of it's Customer. That Customer field was still there, just not as a parent. BUT. When I went back to that record, and again selected the "Record is Parent" check box, the up-until-now-completely-invisible "Parent Subtab" drop down reappeared. And guess what was still selected. DING DING DING! My immortal custom Subtab. I changed the selection in the drop down, unchecked the "Record is Parent" box, and saved.
With bated-breath I tried deleting the Subtab again. VICTORY!!!!! This is why they pay me the big bucks :cool:
In all seriousness, this is an understandable, but pretty annoying little issue. In my opinion, the "Parent Subtab" should 'forget' its value if "Record is Parent" is not checked. Also...NetSuite should really be able to tell you the Record's dependencies if it won't let you delete it.
Hope this help someone else some day. Cheers.