Skip to main content
Cartegraph Campus

Create a Library from a Lookup Relationship Example

This feature requires a Cartegraph OMS license.

The city would like to add an emergency contact name of someone in the Maintenance Department for each piece of equipment that the city owns. The System Administrator is adding a new field to the Equipment recordset called Emergency Contact. This field is a lookup to a new library called Maintenance Emergency Contact.

You must have administrator rights to access this feature.

  1. Click Screen Shot 2018-04-12 at 3.27.44 PM.png>Structure Manager.
  2. Locate and select the Equipment recordset.
  3. Click Create>Field.
  4. Select the Field Type of Lookup and click Done.
  5. In the General section, enter Field Name as Emergency Contact. The ID and  Column Name automatically populate from Field Name.
  6. In the Lookup Source section, click Select Lookup.
  7. The Maintenance Emergency Contact library does not currently exist; click Create Library.
  8. Enter Maintenance Emergency Contact as the library name and click Add Name. 
  9. Click Done. 
  10. The Lookup Source Target selection closes and the Lookup Recordset and Unique Field are populated based on your field creation screen.
The new library, Maintenance Emergency Contact, is added to Cartegraph with a unique and required field called Emergency Contact.
  1. Click Save
  2. Click Publish.
The Emergency Contact lookup field in the Equipment recordset is added to Cartegraph. Add the emergency contact information to the Maintenance Emergency Contact library using Library Manager. The library data is available from the Equipment recordset.
  • Was this article helpful?