I have now added an additional field to the sales table called ‘Price’. We will use this field to enter product price data on the subform. Ideally we would want to create a dropdown which selected the product and automatically dropped the price in the subform, but I will show how this is done in another tutorial.
So now our screen looks as follows: