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

So I ran a SuiteQL query and two multiple select fields returns “RELATIONSHIP FIELD”  rather than some data I would have expected. Any idea’s what is going on here?
```[
  {
    "owner": 1648,
    "isinactive": "F",
    "custrecord_rfi_trm_fulfilment_number": "RELATIONSHIP FIELD",
    "lastmodified": "17/05/2021",
    "created": "17/05/2021",
    "name": "973",
    "externalid": null,
    "id": 973,
    "custrecord_rfi_trm_ship_nr_det": 836,
    "custrecord_rfi_trm_salesorder": "RELATIONSHIP FIELD"
  }
]```

So it turned out that when I use BUILTIN.DF() for those multiple select fields I get something back. However I would have expected the internal id’s of those records instead instead of the trandisplayname :S
```SELECT 
	--*,
	BUILTIN.DF(custrecord_rfi_trm_fulfilment_number),
	BUILTIN.DF(custrecord_rfi_trm_salesorder)

FROM
	customrecord_rfi_trm_shipment_details
WHERE 
	ID = 973```

```[
  {
    "expr1": "Item Fulfillment #IF00000436",
    "expr2": "Sales Order #SLS00000658"
  }
]```

In the Records Catalog, do you see joins on those fields? There should be a join table between them and the related tables.

Hi <@U856E2SEA> thanks for the tip. I’ll check it later