AnsweredAssumed Answered

Table structure question

Question asked by WF7A on Oct 7, 2014
Latest reply on Oct 9, 2014 by philmodjunk


Table structure question


Greets, all:

I'm a little perplexed so I need your help; please refer to the attachment.

I have four "domains" that I want to create a parent-child relationship since, as you can see, each domain has multiple fields which will be used in summary/aggregate reports later. (Each red square is a field where users would enter a number from 1 to 4; they're named D1a, D1b, D1c...D3c, D3d, D3e.) Since there's a one-to-many relationship I need to create parent-child tables.

Here's the question: Should I create a separate child table for each Domain, e.g., Domain1 would store only the Domain 1 data, Domain 2 for only Domain 2 data, etc., or should I have one child table to store all the data, it broken out by data field and Domain number?

TIA for your input!