I want to make an Access database that could track all the Paymts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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]
 
Back
Top