>>>Hello,
>>>I need to show the contents of a table like a spreadsheet.
>>>The table is structured like:
>>>Color Size Order
>>>001 S 10
>>>001 M 5
>>>001 L 6
>>>002 S 8
>>>002 M 9
>>>
>>>The grid (or whatever) should reflect the contents like a spreadsheet:
>>>
>>>Color S M L
>>>001 10 5 6
>>>002 8 9
>>>
>>>The difficult part is, that the spreadsheet is editable (if the user changed the Number of orders, I want to change it in the table), and that the number of columns (and their names) vary according to the existing records. This means, if no size L exists for a selection, this column should not show up.
>>>Any ideas??
>>>I would be very happy, if someone could help me to find a solution.
>>
>>Can you create a CROSS TAB Query? That will total to one line by color and size. Make that a source for your grid and Poof i think that you are done.
>>
>>This is not editable back to your raw data though, it's more of a reporting on stock approach.
>
>That's exactly my problem, I have to get this editable. So that's not an easy one?

What is going to be edited? All I see is that I have a total per size. If I sell one, or ship a dozen, that is on the individual line item:
Color Size Order
001 S 10

to become
001 S 8

You can write code to fire off a verification when you chage a cell in the grid. It can go back to the raw data (primary key is color + size) and change that value. That is not as automatic as a table update is.