In this tutorial we will create a parent form from an entity table and use a query to create a subform from a transaction table and another entity table. We will create a relationship between the parent and child field to filter the records for the parent. We will conclude with the creation of some unbound calculations in the subform footer using the SUM and Count functions.
