[RESOLVED] Best approach to Update a Database?

[RichardKnox]

Hello,

I am writing a program to assist Paramedic students in learning the Drugs that they have to know in order to pass their classes. I have created an Access database to hold all the information on these drugs, but not every student that will use this program will need to learn all the drugs contained within this database.

Right now I have 43 drugs in the database and still growing.

What I want to do is to present to the student the drugs and have them say "Y" or "N" as to whether its on their required list to learn. That way they only work on the ones that they need to.

I thought about presenting a list of about 15 drugs per page and have them select or deselect the ones they need to learn. But, I am uncertain how to do this. I know how to present one drug at a time, but once the database gets larger, that could take some time for them to work through.

Any suggestion and direction as to the best way to do this, would be greatly welcomed.

Thanks,

Richard

[mickey_pt]

I think the best way it's to use a datagridview with two columns, the first one shows the drug, the second will be a checkboxcolumn, to set if the student will need the drug in the list to learn...

[CoachBarker]

Even simpler use a checkedListbox, let them select all the drugs they need to study then do a for each loop on the checked items to populate the required drugs information into a textbox that they can navigate back and forth through.

[RunsWithScissors]

Is it possible to categorize the drugs in the database?

I dont' know much about paramedic training, but would the students be needing to access certain categories of drugs? Say "Pain Management" vs "Re-start-your-heart" drugs (I am sure there is a medical term for the latter)?

If so, you could add a Drug category table to help students narrow their search down when. Then just put some type of category selection mechanism above your DGV or CheckedListBox which would filter the contents of said DGV or checkedListBox by category.