crosstab like display and data entry

[Guest]

Hi,
I'm working with a table that looks like this:

model category level
---------- ------------ -------
model 1 category 1 A
model 1 category 2 A
model 1 category 3 B
model 1 category 4 A
model 2 category 1 A
model 2 category 3 C
model 2 category 4 B
.....

The combination model/category is unique and categories will be limited (say
to max 30).
Users would like an "excel-like" data-entry form (grid) where they can
change ONLY the level field
this would look like this:

category 1 category 2 category 3 category 4 .....
--------- ------------ ------------ ------------ ------------
------------
model 1 A A B A
model 2 A C B
model 3
.....

this would (i think) have to be done in a "dynamically" created form,
somewhat "crosstab" like, but with no grouping and data aggregation
functionality, but with the possibility to edit the "level" data in the grid.
The edited data would have to be updated in the table.

All suggestions would be very welcome

-- enthousiastic going on ....

 

[Guest]

You could use the crosstab as the source for an append query. The table
appended to could be the record source for your form. You would need code
that would write updates back to your normalized table.

 

[Peter Hibbs]

Guido,

You could do this using a Flex Grid control. Have a look at my Flex
Grid demo program at -

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for some examples, although the VBA code required to update the table
would be fairly complex.

Good luck.

Peter Hibbs.