Thank you, it turns out my database is a Data Repository database that is copied from a live (production) database and no links/relationship get copied over.

Which permissions should we be looking at? Nothing on google on how to check this or which permission are needed. Thank you.