APEX

Hi - I'm using oracle 10g xe and apex 2.2 (constraints from the university server - i know).

I have a table
Tests
-testName
-testType
-testResult
-isImage

Where isImage is t/f if the testResult should represent an image file (based on the test type).

I'd like to have testResult represented on a form by either a radio group that has the possible images, which will conditionally appear if isImage is true (done - got this working) or by a textfield if it is just to be a free-form result (also got this working). To do this, I change P17_testResult visibility based on the isImage flag. I've created a new dummy item as a radio group, P17_testImages, and I am trying to assign the value of P17_testImages to P17_testResult before writing to the db. P17_testResult maps to the database column testResult. I've tried also having P17_testImages point to the column, but I get a duplicate column error. No matter how I try, it doesn't seem to work. I've tried adding a computation based on item value, putting P17_testImages in for P17_testResult, tried writing procedures that will do the assignment, etc, but nothing seems to work.

How, can at the time of submit, I change the value of one page item to that of another? I'm sorry if this is a real beginner question, but i'm pretty new with apex.

Thanks so much

-glen