Need some design help

  • Thread starter Thread starter Joe Cilinceon
  • Start date Start date
J

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

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