Hi All,
I am developing a web-based application for my friend for a process that uses an Excel sheet currently.
I have attached the Excel sheet for reference.
I have created the database structure as under:
entity
-eno
-ename
check
-eno_fk
-cno
-check_text
-check_field1
-check_field2
-check_field3
-check_field4
-istitle
steps
-cno_fk
-stepno
-steptext
obs
-stepno_fk
-obsno
-obstext
-obsdate
eff
-cno_fk
-effect
-edate
I want to know the optimal way of writing a query to display the excel sheet structure in the web-based application.
I have written a query, but for each “step” the “check_text” is repeated.
I need help in how to query in a way such that I can display the exact structure of the excel sheet.
Hope somebody can help!!
Other tips are welcome too
Thanks and Regards
Sam