Lookup vs Choice vs Choices vs Customer column

This sheet compares Lookup column, Choice column, Choices column, Customer column.

CriterionLookup columnChoice columnChoices columnCustomer column
HoldsA reference to a single row in a target tableOne value from a defined option setSeveral values from a defined option setA reference to either an account or a contact

The verdict, the full comparison, 4 rules and 2 traps are part of PL-900 access. Unlock PL-900.