the maximum number of questions on a check-list at the moment is about 130
the maximum number of questions on a check-list at the moment is about 130
I think you misunderstood. But not to worry.
With the attached could you please populate the forrloing Tables.
tblEquipment 3 Records
tblEquipmentType 3 Records
tblChecklist 40 Plus records
tblChecklistAnswer One For each Checklist.
That took me ages without forms and default values, also may I add some answers will be incorrect as well as I do not know what some of the questions mean tbh.
You will notice I also made the Answer2 field in answers table as well this is because every question has 2 parts the answer/ comment in addition to the 'yes, no or N/A' response which i made '1, 2, or 3' respectively
As per the answers it is apparent that non-compliant answers will be the most different however all answers including yes and no answers are usually very different as well
I think this is a fairly accurate, if not somewhat brief account of the questions and answers from the different check-lists
Thanks
Did you mean to attach something?
Ha... apologies
Here it is now
Attachment 4489
Hi Rain hope you had a good weekend, just a quick one with the check-lists table structure. Have I populated this database correctly (as you expected) and is the design correct/ still what you think may be the best way of doing things? Thanks
Just needs a couple of adjustments.
Will get back in a couple of hours.
Just got to finish some work for a Client.
It doesn't appear to be any repeating Data in tblCheckList so that table appears correct.
tblCheckListAnswer does have Repeating Data like, Clean, Not Sighted, Inspected and Sighted. You could have a Joint Table between tblCheckList and tblCheckListAnswer which would comply with the rules of Normalisation.
But the amount of repeating Data at this stage does not appear to be significant so you may decide to leave this alone, unless of course with additional data there is likely to be much more repeats then you should eliminate the repeating data and create the Join Table.
OK that's good news I will start all the coding then if the structure looks good. fairly busy at the moment so may not get it done as quickly as I would like.
There will no doubt be repeats of some questions and definitely some answers I think answers like sighted and not sighted will actually be repeated quite a bit inevitably as there will be very few non-compliances per inspection, in this case would you recommend a slightly different design. However it is not as easy as saying whenever someone chooses 1 then it is sighted as there will still be variation. Additionally if Non-compliant or 2 is selected than the answer will be different 99% of the time.
If I then decide this is the design then I need to start coding the answers part of things and I assume I would do this in vb by saying something like if EquipmentTypeID= 8 then it opens this specific form (Example 2) and for each question validates by checklist id so if on this form the specific question is ChecklistID = 45 then default = Sighted in the forms text box/ combo box code and the value can only be 8 digits somehow in vb code as mask in the text or combo boxes code
Is this correct?
Go for it.
But look at the opening times in that Database I sent you. The code behind it may help.
It might be time to start a new as your future questions will be on Form design rather that Table structure.
This will encourage other to help as well.
I believe that all is fine to go but I am only human. So you may need to tweak things a little.
Excellent, I think I will do just that, thanks for everything you have been a great help.
Just Noticed tblInspectionDetails.
What are all the fields about???
47 Fields are a lot.
Thanks Rain
Not to worry about this one... must have been an old version where I had a check-list as a table - this has been superseded by tblChecklist now and there is no requirement for this table any longer.
Thanks. Just checking.