top of page
Search

Picklist or lookup

  • Mar 4, 2010
  • 1 min read

When creating new attributes for an entity the obvious data type is a picklist - especially when there are only a few valid choices such as Title (Mr, Mrs etc).

However, picklists are not without some problems and in some situations it may be better to create a new entity and a 1:n relationship between the main entity and the new entity.

The table compares picklists and using entities.

Picklist

Lookup Entity

Easy for user to select value

More clicks than picklist to select the value

Can't be reused between entities

Can be used on more than entity (create additional relationships)

Can't be set using a dynamic value in Workflow

Easier for users to maintain (just add/update/delete records)


 
 
 

Recent Posts

See All
New AB Exams from Microsoft

Four new exams with related courses and the prefix AB were released by Microsoft during December 2025 and January 2026. These are summarized in the table below. Exam Study Guide Title Link to Course A

 
 
 

Comments


bottom of page