How to Use a Choice Field in a Lookup Column Using SharePoint and Microsoft Lists
SharePoint and Microsoft Lists are powerful tools for creating and managing data in various scenarios. One of the features that they offer is the ability to create lookup columns, which allow you to reference data from another list in your site. This can be useful for creating relationships between different types of data, such as customers and orders, products and categories, or employees and projects.
However, not all column types can be used as lookup fields. One of the column types that is not supported by default is the choice column, which lets you create a drop-down list of predefined options for your users to select from.