New Record - send email HELP! :(

[ThorstenG]

Good afternoon everyone I need some help please.



In my database I need to send an email to approve the new record - however I have various departments which need to approve this so at the moment it looks like the table below:

So what am after is, once the new record info is entered in the form (which I have). So Dep 1 needs to approve the record and so does Dep 2.. and so on (there are 10 departments).

However am not sure how to link the email addresses to the column and I only want to send each department the details about the record (or records) and their 3 questions whicha er Date Approved / Comments and Initals.

Do I need seperate tables? if so how do I link them? or how would you set it up?

Would really appreciate any help I can get.. thanks guys.

Record info 1

Record info 2

Record info 3

Department 1 Date Approved

Dep 1 Comments

Dep 1 Approval Initial

Dep 2 Date Approved

Dep 2 Comments

Dep 2 Date Approved

[ranman256]

I would layout 3 tables.

table: tMainRec (your main recs to approve)
RecID
etc...

table: tEmails (the emails for all depts)
Dept: dept1
Email: myemail@co.com

table: tApprovals (approval for the Main Record)
AprID
RecID
Dept
DateApprov
Comment
Initials


Master table tMainRec, links to child table tApproval
Emails to all depts would come from the tEmail table AND populate the tApproval table with Dept names but have null dates

Each dept need approve in tApproval table. When all dates are filled, it is approved.

[ThorstenG]

Brilliant thanks Ranman.. I will try this.. may I come back with more questions if it doesnt work?

[ranman256]

Yep. I'll be here.

[ThorstenG]

Yep. I'll be here.

HI Ranman,

thanks again for your comments yesterday - I now have it set up as seen in the attached.

Would you do this the same way?


tmainRec ID links to APRID in tapprovals.
Tapprovals approvedby links to temails Intitals..

When I look at the record when i tried a sample, it gives me approvedby and approvedwhen plus comments, but it doesnt say which dept... which I thought should come through this... would you know how to add this?


Many thanks.

T