Calculated Columns

Some stencils use strings computed from other related tables ( i.e. foreign key tables). For example, in the Chinook database, the Customer table is a foreign key table to the invoice table:

So, we may want to display Customer.FirstName +", " + Customer.LastName as a calculated field in the Invoice table to enhance how some stencils are able to generate code.

 

1. Column Name - This is the name of the column. Note: this column is not physically available in the table schema.
2. Set as Table Label.
3. Formula - This is the formula used to generate the required calculated string.
4. Foreign Key Table - This is a grid representing the foreign key table with all the available columns listed.