Hi Kris, First I would like to thank you for responding to my post, it is greatly appreciated. I will try to answer your questions in the order you presented them.
Q1 - The ultimate goal of this project is to display a listing of the annual training calendar and show what training a given employee has and has not completed from that list. Q2 - Whether this can be accomplished with a single query or multiple queries, makes no difference to me. Q3 - Expected output would be something along the lines of this row 1: trng_code --- trng_title --- completed row 2: trng_code --- trng_title --- not completed row 3: trng_code --- trng_title --- completed and so forth running the through the table containing the annual training event information. Q4 - Not sure what you are looking for with this question. Q5 - Table structure >>> tbl_personnel --- record_id = key --- first_name (varchar) --- last_name (varchar) --- emp_id varchar >>> tbl_training_calendar --- record_id = key --- trng_code (varchar) --- trng_title (varchar) >>> tbl_training_completed --- record_id = key --- trng_code (varchar) --- emp_id (varchar) --- trng_status (varchar) With my current thinking process, the only time there would information entered into the tbl_training_completed table, would be when the individual actually completed said training. This I am having no problems with query and displaying. However, the issue I am having problems with is, determining what training of the scheduled training the individual has not done so I can include it in the same display / output in the layout described in Q3. The more I ponder on the scenario, the more I am becoming convinced it cannot be accomplished without pre-loading the trng_status field of the tbl_training_completed table with 'not completed' or NULL and query/evaluate against that. With there being 63 individuals and about 75 different training elements, pre-loading does not look pleasant. I am certainly open to suggestions on easier / more effective ways to accomplish this. I can do messengers as well as offer a virtual meeting session, if this would make reaching a solution easier. Thanks in advance, I hope I answered your questions. Leonard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
