Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2012
    Posts
    1

    Database design: Form data causing circular reference?

    Dear,

    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...

    Best regards!
    Attached Thumbnails Attached Thumbnails formdesign.PNG  

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •