I am seeking conceptual here on how to get started with a "3D Matrix"
in Access. We run a training center which holds multiple classes in
multiple cities at multiple times. So I need to create a matrix with
3 "axis". The 3 axes are:
City Location
Week of Class (in 14 week increments that repeat)
Name of Class
The end goal is to be able to have a form that shows these classes in
a grid, and the user can double click on the grid and open up a dialog
box that will allow them to add registrants, instructors, etc...
Before I delve too far into this, I want to be sure I'm going down the
right path. My ideas so far are to do it with a crosstab query, or to
set up a "base schedule" table from which mathematical calculations in
queries repeat scheduling patterns, or to do the whole thing with
formulas, etc... I'm actually pretty lost as I've never worked with
crosstab queries before and don't know if they are they right way to
go, or if the whole thing can be done with VBA coding like a lot of
calendars I've seen in Access.
Here is a link to where you can see what the structure and patterns
are like:
Just looking for some general principles and guidelines here on how to handle the
patterns and form design. Thanks for any much needed help!!!!
in Access. We run a training center which holds multiple classes in
multiple cities at multiple times. So I need to create a matrix with
3 "axis". The 3 axes are:
City Location
Week of Class (in 14 week increments that repeat)
Name of Class
The end goal is to be able to have a form that shows these classes in
a grid, and the user can double click on the grid and open up a dialog
box that will allow them to add registrants, instructors, etc...
Before I delve too far into this, I want to be sure I'm going down the
right path. My ideas so far are to do it with a crosstab query, or to
set up a "base schedule" table from which mathematical calculations in
queries repeat scheduling patterns, or to do the whole thing with
formulas, etc... I'm actually pretty lost as I've never worked with
crosstab queries before and don't know if they are they right way to
go, or if the whole thing can be done with VBA coding like a lot of
calendars I've seen in Access.
Here is a link to where you can see what the structure and patterns
are like:
Just looking for some general principles and guidelines here on how to handle the
patterns and form design. Thanks for any much needed help!!!!