Peter Tanswell wrote: > > I will probably save the selected practice areas in one field > probably as a string.
I would recommend against this...create a table to store the individual practice areas associated with a employee...something like tblEmployeePracticeArea employeeid practiceid Then when editing, you could do your query as something like... <cfquery name="qGetPracticeAreas" datasource="#request.db_dsn#" username="#request.db_login#" password="#request.db_pwd#"> SELECT p.practiceid,p.practicearea,e.employeeid FROM tbl_practiceareas p LEFT JOIN tblEmployeePracticeArea e ON p.practiceid = e.practiceid AND e.employeeid = #employeeiamediting# ORDER BY p.practicearea </cfquery> Then in your select... <select name="practicearea" size="4" multiple="multiple"> <option value="0">Please Select</option> <cfoutput query="qgetpracticeareas"> <option value="#practiceid#"<cfif employeeid IS NOT ""> selected</cfif>> #practicearea#</option></cfoutput> </select> You might also want to think about using check boxes instead of the multi select list. I've found that users often find the holding of the "ctrl" key thing to be cumbersome. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261593 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
