Database design: Form data causing circular reference?
I am trying to make a database structure for saving form data.
As I think of it now, I would need six tables: 3 for the metadata or the "layout" of the forms (Form, Group, Field), and 3 for the submitted data (Form_Header, Group_Header and Field_Data).
But in my current design (see attachment), I see a problem in Field_data for example, that it can contain a couple Group_Header_ID-Field_ID where the field has no connection to that Group... I think this is due to circular references?
How can I avoid this? I would like to stay away from triggers for this...