Populate Form with CrossTab queries and add records to them.

[anirudh]

Hello all,
I want to know if this is even possible.

This is my DB structure

Table
SampleDate :

SampleID SampleDate Comment
1 1/1/2005 X
2 1/1/2006 Y
Table DateParameters :

SampleID ParameterID Value
1 AG 0.1
1 AL 0.2
1 MG 0.3
2 AL 0.6
2 MG 0.5
Now, I want to create a form where I need it to look like this for
example when the SampleID = 1

SampleDate AG AL MG
1/1/2005 0.1 0.2 0.3

1). I guess this is possible using a crosstab query. Where do I find
examples of how to dynamically attach a crosstab query to a form's
input ?

2). Can the users update these values and then how will they be stored
back in the database ?

3). Can they add new records (new values for AG,AL and MG on new dates)
? how will they be updated as two tables have to be updated ?

Any articles which illustrate this would be highly appreciated too.
Please remember that I need this for an interactive form.
Thanks,
Anirudh Garg

[PC Datasheet]

The answer to 2 and 3 is No. A crosstab query is not updateable.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"anirudh" <an*********@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hello all,
I want to know if this is even possible.

This is my DB structure

Table
SampleDate :

SampleID SampleDate Comment
1 1/1/2005 X
2 1/1/2006 Y
Table DateParameters :

SampleID ParameterID Value
1 AG 0.1
1 AL 0.2
1 MG 0.3
2 AL 0.6
2 MG 0.5
Now, I want to create a form where I need it to look like this for
example when the SampleID = 1

SampleDate AG AL MG
1/1/2005 0.1 0.2 0.3

1). I guess this is possible using a crosstab query. Where do I find
examples of how to dynamically attach a crosstab query to a form's
input ?

2). Can the users update these values and then how will they be stored
back in the database ?

3). Can they add new records (new values for AG,AL and MG on new dates)
? how will they be updated as two tables have to be updated ?

Any articles which illustrate this would be highly appreciated too.
Please remember that I need this for an interactive form.
Thanks,
Anirudh Garg