I want to make an Access database that could track all the Cheques from
Customers and that could be linked to Customer statement that shows the
oUTSTANDINGS
Ok; do so.
Create a new table named Payments, with a CustomerID linked to the
Primary Key of your customer table, or, depending on your
datastructure and business rules, a StatementNumber linked to the
primary key of the Statements table. Put any fields that you need to
see in this table. Use a Form based on Customers (or Statements) with
a subform based on this new table.
Remember - we cannot see your database structure; you can. If I'm
missing the boat post back with some more details.
John W. Vinson[MVP]
