Following up on my initial follow up post. I realize I was jumping ahead to access 12.1 with an OrderListF question. I now know the correct way to do it using a query with an aggregate sum function. However, I'm simply experimenting on my own as I work through the lessons. I thought setting the source of an OrderListF to the OrderT and then setting the control sources for the CustomerName and Total to the OrderF would work...but it didn't. Not sure why though, relative to all the internal logic of access/database design. If there is an easy explaining please provide. Otherwise feel free to dismiss question and forego publishing these comments in the forum. Thanks.

---

Reply from Alex Hedley:

You can only set Controls to be bound to a value on the underlying record source