thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Business Platforms & EA · Foundational

Lookup Relationship

Loosely coupled relationship linking one record to another, where the child has its own owner and sharing.

Definition

A lookup field links a record to a parent but does not cascade sharing or necessarily delete with the parent. The field can be optional or required, and on parent deletion the lookup can clear the value, block deletion, or (for some cases) cascade. An object can have up to 40 relationship fields.

Example

A Case has a lookup to an Asset record.

Exam tip

Lookup children keep their own owner and sharing; roll-up summaries require master-detail, not lookup.

Don't confuse it with

Related terms