Edit

Share via


Add fields to tables through extension

Note

Community interest groups have now moved from Yammer to Microsoft Viva Engage. To join a Viva Engage community and take part in the latest discussions, fill out the Request access to Finance and Operations Viva Engage Community form and choose the community you want to join.

To add a new field to an existing table, you must first create a table extension. For example, to add a field that holds the radius of the released product, you must create an extension for the InventTable table in your model, as shown in the following illustration.

Create an extension.

You can now add the field to the extension, just as you would add a field to a table in your model. You can use two methods:

  • In the designer, right-click the Fields node, select New, and then select the type of field to add.
  • Drag an existing Extended Data Type or Base Enumeration from your project onto the Fields node.

When you've finished, you can modify the properties of the new field. In the following illustration, only the Label property was modified.

Modify properties of the new field.

You can now optionally add the new field either to one of the existing field groups or to a new field group that you create. In the following illustration, the Radius field was added to the PhysicalDimensions field group.

Add the new field to a field group.

After compilation and synchronization of the database, you can see and edit the new field in the user interface.

New field in the user interface.