Process Flow - Query design - LawsonGuru.com

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1357
Roger French	1311
mark.cook	1244

kbfinn

New Member

Posts: 2

8/7/2006 4:49 PM

I need to create a process flow that to assist with auditing emergency contact details. I want to send an e-mail to each individual employee with a list of all the emergency contacts they have recorded in the system.
I can only seem to create a flow that sends the employee one email for each contact they have in the system.

Thanks for any help with this.

John Henley

Posts: 3352

8/7/2006 6:20 PM

You would use nested queries to accomplish this:
- The outer query would return the list of employees. In that query loop you would perform an inner query of contacts for that employee, and compose and send the email to that employee.

I've attached a picture of what it look like.

John Henley

Posts: 3352

8/7/2006 6:20 PM

You would use nested queries to accomplish this:
- The outer query would return the list of employees. In that query loop you would perform an inner query of contacts for that employee, and compose and send the email to that employee.

I've attached a picture of what it look like.

John Henley

Posts: 3352

8/7/2006 6:20 PM

You would use nested queries to accomplish this:
- The outer query would return the list of employees. In that query loop you would perform an inner query of contacts for that employee, and compose and send the email to that employee.

I've attached a picture of what it should look like...

Attachments

18726156571.zip