When should you use choice columns vs lookup tables?

Short Answer
Views 7

Answer:

Use choice columns when:

  • Options are limited

  • Multilingual support is required

  • Values rarely change

Use lookup tables when:

  • Options are large

  • Non-admins manage values

  • Historical values must remain

  • Advanced searching is needed

Related Articles:

This section is dedicated exclusively to Questions & Answers. For an in-depth exploration of MB-700: Microsoft Dynamics 365: Finance and Operations Apps Solution Architect, click the links and dive deeper into this subject.

Join Our telegram group to ask Questions

Click below button to join our groups.