How to enter relational data in tabular format?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I've a relational table with structure like (category1, category2, value)
and records e.g.
A, X, 10
A, Y, 11
A, Z, 12
B, Y, 13
C, X, 14
Now I want to edit this table in a tabular format, like a datagrid:

X Y Z
A 10 11 12
B 13
C 14

How can I do that?

Thanks for suggestions

Henk
 
Crosstab queries aren't updatable.

The only way I've ever solved this is to create a temporary table with the
data arranged in the tabular format.
 
Thanks for your suggestions.
In my case a temporary table was also a problem, for the categories are
variable.
Now I've solved my problem with a spreadsheet component which I fill and
read with VBA

Regards,
Henk
 
Back
Top