This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is there a way to query dependent records? I'm trying to delete records but I don't know what's been attached to them.

I'd love to know this too, my current method is ... wait for it to fail the delete process then you know it has dependent records :confused:

just brainstorming... you'd need to check every list/record field type of type %recordType%
where the value is %recordId%

i think? actually that might not work, if there are files attached to a record are they dependent records? I don't think they'd have a refernce to the record they're attached to, that relationship lives on the records you're trying to delete :thinking_face:

I was just assuming we're looking for any instance where the record to delete is a foreign key, but I'm not sure that would be everything