Enter table data in columns

[Guest]

I need to enter percentages by product for each business unit and function.
I would like to display the data entry form in kind of a crosstab format as
such:

BusUnit Function 100 110 120
41100 0005 .25 .35 .40
41100 0010 .30 .50 .30

But the data is stored in the underlying table in a traditional "table"
format:

BusUnit Function Product Pct
41100 0005 100 .25
41100 0005 110 .35
41100 0005 120 .40
etc...

I just found out a crosstab query is not updatable, so I can't use that as
the data source for the form. I'm sure someone has run across this issue
before - any ideas?

 

[Guest]

How many products do you have, how many will you have next month, next year,
etc? See the problem? You are pretty much stuck with what you have.