Index: openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql,v
diff -u -N -r1.18 -r1.18.2.1
--- openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	14 May 2009 13:15:57 -0000	1.18
+++ openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	16 Aug 2009 23:21:22 -0000	1.18.2.1
@@ -196,8 +196,8 @@
 begin
 
 select title into v_choice_value
-from as_item_choicesx
-where choice_id = NEW.choice_id;
+from cr_revisions
+where revision_id = NEW.choice_id;
 
 update as_item_data set choice_value = coalesce(choice_value,'''') || '' '' || coalesce(v_choice_value,'''') where item_data_id = new.item_data_id;