Need some design help

[Joe Cilinceon]

What I have is database (still developing) for a small storage business. We
have it setup to print letters like invoice, late letters, balance due etc.
I need some suggestion on how to setup a system that will log a date and
type of letter sent for each tenant. All letters are generated using Access
XP report generator. Any input on the best way to accomplish this would be
greatly appreciated.

 

[Armen Stein]

What I have is database (still developing) for a small storage business. We
have it setup to print letters like invoice, late letters, balance due etc.
I need some suggestion on how to setup a system that will log a date and
type of letter sent for each tenant. All letters are generated using Access
XP report generator. Any input on the best way to accomplish this would be
greatly appreciated.

Hi Joe,

You'll need another table, say tblCorrespondence, related to your Tenant
table on TenantID. It will have the TenantID, CorrespondenceType, Date,
etc. Whenever you print a batch of letters or invoice, use an append
query to add a record to that new table for each TenantID that's getting
a letter.

If you have someone familiar with Access development, they should be
able to set this up for you.

Hope this helps,

--
Armen Stein
Access 2003 VBA Programmer's Reference
http://www.amazon.com/exec/obidos/ASIN/0764559036/jstreettech-20
J Street Technology, Inc.
Armen _@_ JStreetTech _._ com