Crosstab form

[John Baker]

I am trying to develop a form which will allow me to track data in a
crosstab like form.
The form is to contain MainSpecifications, Criteria, Categories and a letter
value in the following way.


-------------------------------------------------------|
Main Spec1 |
-------------------------------------------------------|
| Category1 | Category2 | Category 3 |
------------------------------------------------------ |
Criteria1 | A | | B |
------------------------------------------------------ |
Criteria2 | B | |
|
------------------------------------------------------ |
Criteria3 | | C |
|
------------------------------------------------------ |
Criteria4 | C | | A |
------------------------------------------------------ |
Criteria5 | | A | C |
------------------------------------------------------ |

There will be many other Mainspecs (eg Mainspecs2, Mainspecs3 etc) which
follow the above pattern
The letter values are what will be entered into on the form (There may be no
letter entered at all. i.e. it could be blank!). All other values ie
Criterias, Categories and Mainspecs are obtained from a table which relates
the Criterias, Categories and Mainspecs. There can be up to 8 Categories and
up to 30 Criteria. There maybe up to 100 different Mainspecs.
I would like to have one mainspec per screen. The number of Categories will
be fixed but the number of Criteria may be different for each Mainspec.

Is anyone able to suggest how I might go about setting up something like the
above?

Any help greatly appreciated.
John Baker
(e-mail address removed)