SELECT DISTINCT(participants.ID) AS ID, participants.FirstName, participants.LastName, participant_module_links.ModuleID FROM participants LEFT JOIN participant_module_links ON (participant_module_links.ParticipantID = participants.ID AND participant_module_links.ModuleID = '#Client.ModuleAddID#') WHERE participants.ProjectID = '#Client.ProjectID#' AND participants.PrimaryColor <> '' GROUP BY participants.FirstName ORDER BY participants.LastName, participants.FirstName SELECT ID, ModuleName, FileName, UnitCost FROM modules WHERE ID = '#Client.ModuleAddID#' ORDER BY ModuleName Order Modules for a Project Wizard
#Client.StatMsg#
Pick people for whom to order modules

This is the complete list of all people in this project.  To order a module for someone in the project, click the checkbox(s) and when done, click 'Order Modules'.

Please select the people for whom you want to add the #GetModule.ModuleName# module.
The lock icon    indicates a person who has this module assigned already.

There are currently #NumberFormat(GetProj.RecordCount, '9,999')# people with complete assessments in this project.
checked onClick="CheckCount();">   This person already has this module ordered.  #GetProj.FirstName# #GetProj.LastName#
disabled = 'true' onClick="form1.submit();">