# Relationships - Lookups oh boy!
**URL:** https://community.nocodb.com/t/relationships-lookups-oh-boy/2081
**Category:** Uncategorized
**Created:** [September 15, 2025, 7:04am UTC](https://community.nocodb.com/t/relationships-lookups-oh-boy/2081 "2025-09-15T07:04:42Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@craigfer](https://community.nocodb.com/u/craigfer)
#### Post date: [September 15, 2025, 7:04am UTC](https://community.nocodb.com/t/relationships-lookups-oh-boy/2081/1 "2025-09-15T07:04:42Z")
First time user so be gentle. I have lots of MRP (Inventory) data with a SAP NUMBER (174,000 lines), I have a Manufacturer table with MANUFACTURER NAME and MANUFACTURER PART NUMBER that (3000 lines) also has the SAP ID.. I have made the SAP IDs the Display Value. I can create the Link then the Lookup but I really am struggling to bulk update this… I really dont want to do this manually and i dont want to do any import/exports as what’s the point of the database…. Also Claude and ChatGPT has tried and both failed..
---
### Author:  [@Navi](https://community.nocodb.com/u/Navi)
#### Post date: [September 15, 2025, 9:27am UTC](https://community.nocodb.com/t/relationships-lookups-oh-boy/2081/2 "2025-09-15T09:27:04Z")
Hey, if you are using cloud - scripts feature of NocoDB can help. [This script](https://nocodb.com/docs/scripts/examples/link-records-by-field) can you help you to link things quickly.
if self-hosted, you can do the same by using [our APIs](https://nocodb.com/apis/v3/data) to do so.
We ‘ve custom link in private beta in cloud which allows you to link between any two tables. But not yet available for all.
---
### Author:  [@craigfer](https://community.nocodb.com/u/craigfer)
#### Post date: [September 15, 2025, 9:33am UTC](https://community.nocodb.com/t/relationships-lookups-oh-boy/2081/3 "2025-09-15T09:33:22Z")
Navi I am self hosting.. I will try the API.. PS you are much better than Claude AI!
---
### Author:  [@craigfer](https://community.nocodb.com/u/craigfer)
#### Post date: [September 15, 2025, 12:01pm UTC](https://community.nocodb.com/t/relationships-lookups-oh-boy/2081/4 "2025-09-15T12:01:39Z")
Any ideas why the API is failing