Question: what is the difference between lookup and value set?
Answer: What's the difference between a lookup type and a value set? A "lookup type" consists of lookups that are static values in a list of values. ... A table-validated "value set" may consist of values that are validated through a SQL statement, which allows the list of values to be dynamic.