5/22/2023

The Why

Extending standard tables in Dataverse refers to adding new fields and customizing an existing table, while creating a new table involves building a separate table with its own set of fields. Extending a standard table can be a good option if the data you need to add is related to the existing data model. However, if the new data is unrelated or requires a significantly different structure, creating a new table may be more appropriate. When considering whether to extend a table or create a new one, it is important to consider the long-term implications of your decision, such as how it will impact data management and usability.

The How

There are two columns being added to the User Table.

Custom

1. Name-Role
2. Type-Choice
3. Choices-
   1. Lead
   2. Member

Lookup

1. Name-Team
2. Type-Lookup
3. Table-Team

Relationship

From the user table select new Relationship then Many to Many

Select the Project table as the other table

In the next guide we will go over building all the forms and views for the tables.