How to do this?

Hi all,

I have the following problem. I hope that someone can help me with it!

I have two tables with the following structure (please use monospace font):

A_ID A_Description
1 a1
2 a2
3 a3

B_ID B_Description
1 b1
2 b2
3 b3

I also have a third table which combines the two previos tables:

C_ID A_ID B_ID C_Value
1 1 1 <empty>
2 1 2 <empty>
3 1 3 <empty>
4 2 1 <empty>
5 2 2 <empty>
6 2 3 <empty>
7 3 1 <empty>
8 3 2 <empty>
9 3 3 <empty>

I would like to create a form, where users can enter the c_value data in a
cross-tab way:

a1 a2 a3
b1
b2
b3

My brain hurts, and I can't figure out the best way to do this! Can someone
point me into the right direction?

Thanks!
Bami

Olaf
Wed Oct 05 07:32:10 CDT 2005

> C_ID A_ID B_ID C_Value
> 1 1 1 <empty>
> 2 1 2 <empty>
> 3 1 3 <empty>
> 4 2 1 <empty>
> 5 2 2 <empty>
> 6 2 3 <empty>
> 7 3 1 <empty>
> 8 3 2 <empty>
> 9 3 3 <empty>
>
> I would like to create a form, where users can enter the c_value data in a cross-tab way:
>
> a1 a2 a3
> b1
> b2
> b3

You need a table D with

B_ID, D_Value_1, D_Value_2, D_Value_3

That can be bound to a grid for data input and
needs to be transformed to your C-Table design
afterwards.

Take a look at what the cross table wizard may do
for you. menu: Tools->All Wizards->Cross table wizard.

Bye, Olaf.

Andrew
Wed Oct 05 07:36:56 CDT 2005

"Bamibal" <bamibal@eggs.bacon.spam.gmail.com> wrote in message
news:9d2fa$4343bcb2$c3f192a5$23512@cache30.multikabel.net...
> C_ID A_ID B_ID C_Value
> 1 1 1 <empty>
> 2 1 2 <empty>
> 3 1 3 <empty>
> 4 2 1 <empty>
> 5 2 2 <empty>
> 6 2 3 <empty>
> 7 3 1 <empty>
> 8 3 2 <empty>
> 9 3 3 <empty>

Assuming this table is what is supposed to be updated.
Perhaps use genxtab to generate a crosstab cursor and edit it in a grid?
Then go through and update the relevant records.

I'm sure some sort of grid or scrollable thing is the way to go since you
may have too many values to draw them as individual fields for editing.

--
HTH
Andrew Howell