Lookups and links
Contents
Lookups and links alow you to access information from other datasets
Lookups Used when you want to return a single value stored in another dataset based on the value of a property. Works similarly to VLOOKUP in Microsoft Excel
Links Used when you need to map multiple items from one dataset to another. For example a person may work on multiple activities and have many competencies