I am building APEX application for a legacy application which has several poor database design decisions been taken. Unfortunately, I will have to build to that.
There is a student table with previous three qualifications in the same students table. It's in the table as qual1, qual2, qual3. I have to show the qualification data in a tabular form along with student details.
I may need to create a virtual column in the query to number the qualifications and display it in a table
eg. student record : name, age, qual1, qual_desc, qual2, qual2_desc, qual3, qual3_desc. I need to display a single row report something like
student\_name age ........student other details
I have the single row view in a form layout and just want to somehow show this table.
Please suggest how can I tweak the sql query to make this work. Any other solution will do as well.
Thanks