I'm trying to represent and add/remove enrollment of individuals in the database to different programs using two list boxes.
1. Programs: list of programs
2. ActivePrograms: list of programs the individual is enrolled in
I know how to add/remove items from one list box to the other:
my problem is how to represent in the seconed box the list of programs the individual is already enrolled in and to bind it and reflect changes in the "tblPrograms" for each individual
In the SQL database I have two tables:
1. tblIndividuals: information about the individual (with unique ID number)
2. tblPrograms: list of programs with a column for the Indivuduals ID
I was thinking for the 'Programs' table to make the program columns a yes/no columns.
right now I just have the "Programs" listbox showing the list of programs from another table called "ProgramList"
Here is what I need: < ...
Go to the complete details ...