Autopopulating a yes/no box

[BTSA CO]

I've created a database that keeps track of participants completed components
of my program. There are checklist completion items that are numbered 1-89.
These items need to be completed to show completion of standard element 15a,
15b... Let's say if you complete checklist item numbers 16 and 21 you have
completed all requirements for 15a. Is there a way to design it so that
after I check off 16 and 21 that it would automatically check 15a? All
information is located in one table. Should all the information be in one
table or should i create more than one table?

Any help would be greatly appreciated.

 

[John W. Vinson]

I've created a database that keeps track of participants completed components
of my program. There are checklist completion items that are numbered 1-89.
These items need to be completed to show completion of standard element 15a,
15b... Let's say if you complete checklist item numbers 16 and 21 you have
completed all requirements for 15a. Is there a way to design it so that
after I check off 16 and 21 that it would automatically check 15a? All
information is located in one table. Should all the information be in one
table or should i create more than one table?

Any help would be greatly appreciated.

15a is not a number. It's a text string. What's the logic here? Given a
particular checklist number, what determines which "standard element" has been
satisfied? What is the (logical or arbitrary) relationship between checklist
numbers and standard element numbers, and where is that information stored?

I would expect that you would need a field in the checklist table to indicate
that a given value satisfies a particular standard element, but I'll confess
that I do NOT understand the logic or the relationship.

John W. Vinson [MVP]