Summary
In this module, you learned about tables in Microsoft Dynamics 365 Business Central. You also learned about the different technical and functional table types and some basic table properties.
Additionally, you learned about linking to tables in Business Central. You can use the TableRelation property to link tables. These table relations can become complex because it supports filtered and conditional table relations, where the link with another table depends on conditions.
Each table should have one, and only one, primary key that can be a combination of multiple fields. You can define extra secondary keys for performance reasons, but we recommend that you keep the number of keys limited to five or fewer so that you do not negatively impact database performance.
You can use the DropDown fieldgroup to configure which fields should be displayed when a table is used in a lookup. The Brick fieldgroup can be used to configure the small and large tiles that are displayed in a list.
FlowFields are calculated fields that aren't stored in the database. The value is calculated at runtime, and you can use the CalcFormula property. If you want end users to specify a value that is used within this FlowField, use FlowFilters. FlowFilters define placeholders where an end user can enter a value.
Creating a table in AL is as simple as using the ttable, tfield, and tkey snippets.