I am in the process of developing an Access 2002-based system while simultaneously learning Access. I have been able to sort things out pretty well with one notable exception. I would like to be able to invoke an action that will automatically create a new record in a Transaction Table for each record that exists in a Customer Table. My logic is that at the beginning of each billing cycle, a transaction record is created which can subsequently be manually processed when payments are received. Is this doable from within Access, or will it require VB or ???