Views are great high-performance ways to bring data from multiple tables together. We can start with a query and then add fields from that query to a field list in order to create a view that is then created in SQL and is usable as a read-only table anywhere in SCM.
This is great for fact panes, reports, and inquiries. Although we will only cover a simple view in this recipe, the key point is to show how we can create view methods that are used as computed columns in the view. Just like we could add a display method to a table, which is then used in a form, we can also do this in a view. The difference is that the work is done by the SQL Server and comes with two big advantages: they are much quicker to calculate and you can sort and filter on this calculated result. As far as SCM is concerned, this calculated view field is just...
