What do you do when you have two tables, and you want to show them on the same list? Check out one solution to this issue in this video:
Tag Archives: Table
Dynamics 365 Business Central: How to check if a record/table is temporary via AL
Today I would like to share another mini tip about Business Central, how to check if a record/table is temporary in AL.
A temporary table is a temporary variable that holds a table. A temporary table is used as a buffer or intermediate storage for table data.
Dynamics 365 Business Central: How to export all keys in all tables
Today I would like to briefly talk about how to export all keys in all tables.
In AL, a key definition is a sequence of one or more field IDs from a table. You can define keys in table objects and table extension objects, depending on the type of key. There are two types of keys: primary and secondary.
Same table, different number of fields, in AL?
Join me as I brainstorm/prototype an idea for a variable-length record system in Business Central and AL. Instead of needing to create hundreds of staging tables, what if a single table could contain everything? Check out the video:
Table Data Editor 2.0
Table Data Editor 2.0 is a completely free application for data editing in Dynamics 365 Business Central. In general, editing tables directly is very risky, but if you are confident in what you are doing, please go ahead. Below, you will find a description of the main functions and a link to the code and application
Dynamics 365 Business Central: How to save large text/string in the table
Today I would like to talk about how to save large text/string in the Business Central table.
I was asked this question the other day, they want to save a large text in the table. e.g. length of the text is 10,000 characters. However, because of system limitations, it is not possible to create such a long text field.
Lookup any Record, from any Table
Have you ever wondered if you could create more flexible lookups? Maybe you have a function where the user is required to select a record from a specific table, depending on the situation?