Table Browser Form

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Use this browser to inspect data without creating a form or a report.

The Table browser displays data from all fields in the selected table. To limit the fields to the ones that are defined in the AutoReport field group, select Auto-report.

You can edit and delete the records that you browse.

Use the edit field to enter a SQL statement, and then click Execute to apply the statement to the data source.

Example

When you browse the CustTable, the following statement will display only the customers in customer group 40:

select custTable where custTable.custGroup=="40"

Note

The table browser does not support displaying fields of the type container. Therefore, even when you choose to see all fields, container fields are excluded.

Tip

You can use the table browser anywhere a table is used as a data source. For example, in a form, report, or query.

Property settings for a table or a field may prevent you from editing or deleting. If you cannot edit or delete data, check the field property setting for AllowEdit.