nogepog
5 months ago

Display 4 layers of one to many relationships in a single view

Posted 5 months ago by nogepog

I am trying to generate 4 different dynamic forms from database.The form has many types , each type has many subsections,each sub-section (may/may not have) many sub-subsection, each sub-sub-subsection (may/may not have) many sub-sub-sub-section.

For this i have created each table with foreign-key relationship for the successor And all the pk's of these tables as fk references in the form table.

form id|type|subsection_id|sub-sub-section_id|sub-sub-sub-subsection_id|question

how do i display all forms in a list.So that when a user presses form 1 the fields associated open in next page.

Please sign in or create an account to participate in this conversation.