JugglingGeese
Technical User
I have several questions, but I will start with a more basic one about structure:
My database structure is such:
For each File (150 apx)
Display Criteria Set (50 apx)
For each Criteria set in the file
User must answer 1 yes/no question
For each Yes/No Question answered,
user must answer 1 or 2 other questions (depends on their answer to earlier questions)
(so potentially hundreds of possibilities)
In this instance, how would I set up my forms and tables to make sense?
I currently have the following form structure:
Structure of Forms:
Level 1 - frmMain (atm does nothing, has file info for lookup purposes)
Level 2 - sbfCriteria (atm just looksup criteria)
Level 2 - sbfApplicable (y/n to the above)
Level 3 - sbfStandards (if Y)
Level 3 - sbfBasis (if Y)
Level 3 - sbfExplanation (if N)
The following tables exist:
tblFiles (Where the data for the files live) * Key fileID
tblCriteria (where the Criteria for the files live) * Key CriteriaID
tblCriteria_Lookup (where criteria will be written to - not using this atm)
tblApplicable (where Applicable Y/N) is recorded * Key fileID, CriteriaID
tblStandards (Where the standards live)
tblStandards_Lookup (where the standards will be written to)
tblComplianceBasis (Where the Basis data live)
tblCompliance_lookup (where Basis will be written to)
tblExplanation (Where the explanation from the user will be written to if Applicable=N, simple text field.)
Does this structure make sense? Criteria has a memo field in it, which causes some annoying workarounds :/ At the moment I am using "applicable" as my navigation form. From a data standpoint what i have seems to work in the sense that its dumping the data to the correct places...but its causing obnoxious interface issues for the user because all these various subforms have to be synchronized somehow and probably look quite confusing.
Any thoughts?
My database structure is such:
For each File (150 apx)
Display Criteria Set (50 apx)
For each Criteria set in the file
User must answer 1 yes/no question
For each Yes/No Question answered,
user must answer 1 or 2 other questions (depends on their answer to earlier questions)
(so potentially hundreds of possibilities)
In this instance, how would I set up my forms and tables to make sense?
I currently have the following form structure:
Structure of Forms:
Level 1 - frmMain (atm does nothing, has file info for lookup purposes)
Level 2 - sbfCriteria (atm just looksup criteria)
Level 2 - sbfApplicable (y/n to the above)
Level 3 - sbfStandards (if Y)
Level 3 - sbfBasis (if Y)
Level 3 - sbfExplanation (if N)
The following tables exist:
tblFiles (Where the data for the files live) * Key fileID
tblCriteria (where the Criteria for the files live) * Key CriteriaID
tblCriteria_Lookup (where criteria will be written to - not using this atm)
tblApplicable (where Applicable Y/N) is recorded * Key fileID, CriteriaID
tblStandards (Where the standards live)
tblStandards_Lookup (where the standards will be written to)
tblComplianceBasis (Where the Basis data live)
tblCompliance_lookup (where Basis will be written to)
tblExplanation (Where the explanation from the user will be written to if Applicable=N, simple text field.)
Does this structure make sense? Criteria has a memo field in it, which causes some annoying workarounds :/ At the moment I am using "applicable" as my navigation form. From a data standpoint what i have seems to work in the sense that its dumping the data to the correct places...but its causing obnoxious interface issues for the user because all these various subforms have to be synchronized somehow and probably look quite confusing.
Any thoughts?
