Hi Richard, I just have a few questions about this lesson:
1)In the ProductT, shouldn't the Quantity field refer to "the Quantity that costs the UnitPrice" (rather than "the Quantity in Inventory") - or, at least, in addition to that QtyOnHand field (for Calculated fields later)?
2)Do you generally make the Master (ONE) Form a Single Form, and the Child (MANY) Form the Continuous Form?
3)In your Form Footer Totals (Tip), you say that the Total Text Box should be "unbound" (that makes sense...) But if we copy the QtyOnHand field from the Details section (whose control is the QtyOnHand field from the ProductT) - shouldn't that make the SUM(that) still a "bound" field - or at least create that new SUM field with just 1 value in the ProductT?

---

Reply from Alex Hedley:

It's been a while since I've looked at this lesson so may need some fellow students to help out here:

1) You'll want to know how many you have left

2) Depending on what data you want to show but that sounds correct

3) Binding a control makes that value save to the underlying record source (i.e. Table) so if you want to show a Total for display purposes that isn't being stored in a Table then you wouldn't have it bound.