R
rguidice
I've written a database to track information in a casino gaming school.
There are times during the year when all 1000 people contained in the
database must be enrolled into a class. I want to avoid having to
enter a class designation to each student, but would rather do it all
at once. The classes taken table is separate from the table of
associates. I used the make table query, and achieved almost what I
wanted, however the new table I made, and the associates table aren't
related properly, hence the class table doesn't update when a new
associate is added to the associate table. Is there something I can do
about this, or is there a different way to handle the situation?
There are times during the year when all 1000 people contained in the
database must be enrolled into a class. I want to avoid having to
enter a class designation to each student, but would rather do it all
at once. The classes taken table is separate from the table of
associates. I used the make table query, and achieved almost what I
wanted, however the new table I made, and the associates table aren't
related properly, hence the class table doesn't update when a new
associate is added to the associate table. Is there something I can do
about this, or is there a different way to handle the situation?