How to design sql table to store checklist information and more
Just so you know I'm new to VB and SQL.
I'm trying to create a form in vb.net. I've gotten as far as being able to show some of the data that I want, but I need to add a checklist to the bottom of the form and I can't seem to figure out how to design a SQL table that would store the checkbox fields. For example, I want to show the workorder number and the requester from a table called "TASKS" which I've done already, but I need to have another table to store the checkbox or checklist information. The checklist would contain all of the things that need to be done in order to setup a new user. I would have something like Add account to active directory, then a field that said the date it was completed, and them another field that had whom it was completed by. I'm thinking I would have to add the workorder number field in the table so the two tables could be joined.
Any ideas on how I should go about creating a sql table to store this kind of information? If there's a better way to accomplish what I'm trying to do, I'd like to hear that also. Thanks