A Relationship connects two or more object types together (e.g., Company and Business Unit) in Core. Such relationships help you map the big picture for your organization and understand the impacts and accountabilities as you record, track, report, and manage information.
To enter relationship data on the Data Import Template:
Click the Relationship tab to open its worksheet.
Tabs generate in alphabetical order, with relationship tabs labelled with the monogram of the object type they're saved on and their object type group (e.g., R - Control).
Object type tabs are highlighted. See more: Enter New Object Data on the Import Spreadsheet.
Enter the external reference ID (e.g., PERS-1) of the Person object with the relationship saved to it (Row 5, Column A) under OB1 Ext Ref ID.
Enter the external reference ID of the Location object (e.g., LOC-1) that the relationship will pull data from (Row 5, Column C) under OB2 Ext Ref ID.
To import relationships from one object to another (e.g., C-Business Unit), you must enter both objects’ unique External Reference IDs on the Excel spreadsheet.
Object Name in columns B and D are optional fields, meaning that your data import will not fail if those sections are left blank.
Regardless, we recommend adding the Object Name so that you can clearly see what objects are related to one another.
Existing relationships between Objects can't be removed using a Data Import. If required, objects can be unlinked from the reference or relationship object.
Save your changes.