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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291098 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
