How do I set up template to track mailers?

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

Guest

I need a template to track mailers that are sent out which include a job
number, job name, subcontractor name, contract date, date letter mailed.
 
Consider setting up the following tables:
TblSubcontractor
SubcontractorID
SubcontractorName

TblJob
JobID
JobNumber
JobName

TblJobSubcontractor
JobSubContractorID
JobID
SubcontractorID
ContractDate

TblMailer
MailerID
JobSubContractorID
MailerSubject
DateLetterMailed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to join rows of multiple tables through query 5
Invalid Value types in Lookup field 2
Auto Mailer 1
Best methods for tracing a mass-mailing worm infected workstation ona network? 12
Example database or spreadsheet for Billing Projections by month? 1
Due Dates 3
Mailing List Maintenance DB 2
Contract Tracking 4

Back
Top