Need some design help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe Cilinceon - 20 Nov 2004 13:01 GMT

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.

Signature

Thanks

Joe Cilinceon

Reply to this Message

Armen Stein - 28 Nov 2004 07:16 GMT

> 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,

Signature

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

Reply to this Message