I have a form that tracks overdue accounts. Besides the client information, we need to have an area to enter payments made to the account and a balance. A Data Grid would work perfect for this as they can enter the payment data and amount and save it. But, how is the data stored? To me, it seems it would need to be in a separate table with a reference ID pointer to the form entered so that the payments stay with the client info. Does anyone know how that is supposed to work and how to make data grid entries work with a submit or update query?
-Mike