RE: How to search for customer record joined with instances of a custom record which reference that customer record
We have a custom record which has a List/Record field that references a customer record. How can I do a search in SuiteTalk to get some fields from the customer record plus all the instances of that custom record which refer to that customer record?
If it helps to make it clearer:
We have custom record type C. It has field CF, which is List/Record referring to Customer record.
I want to do a search in SuiteTalk which gets Customer where internalid = 1 and all instances of C which have CF referring to Customer with internalid = 1.
Did you set the “Record is Parent” on the custom field setup? That eases having joins in searches.
I can’t edit the custom field – it’s part of a bundle and is locked.
