Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned
|Enabled for||Public preview||General availability|
|Users, automatically||Apr 30, 2021||Sep 2021|
Users will be able to model more complex table relationships by using this new capability. This has been a user/MVP/ISV request for over five years. This capability is also needed by our first party app teams.
Multi-table lookup type columns allow a user to employ a specific table that has multiple one-to-many (1:M) relationships to other tables in the environment. A single lookup type column can refer to multiple other tables. A lookup value submitted to the multi-table type column will be matched to a record in any of the related tables.
Multi-table types are currently built into Microsoft Dataverse as static types like Customer, which connects to both Account and Contact. This new feature gives users the power to define any other multi-table lookups they may need.