I am developing a small workflow application where a child table is used to record the various steps in the workflow (ProcessStep).
Each of the steps has three possible documents attached to it, stored in the filestream column names Document1, Document2 & Document3. But they refer to different things at each step.
e.g. In the Initial step, these Documents refer to
1) The Application Form,
2) The Medical Report;
whilst in another step, the Competency Completion Step they refer to
1) The Personal Track Safety Course results,
2) The Health & Safety Report results.
So, based on what the step is (identified by a value in the ProcessStep.StepName column, I'd like to define what the caption name is on the Form Field along the lines of a CASE statement e.g. for the column Document1
WHEN StepName = 'Initial' THEN 'Application Form'
WHEN StepName = 'Competency Completion' THEN 'Personal Track Safety Report'
Will dbFront have the information from the database in order to do this prior to rendering the Form Fields (I appreciate that it may not be possible to change the table grid column headings from the Document1, Document2, Document 3 names.