group by query bound to check box error msg this record is notupdatable.

[magickarle]

Hi, I got a table resulting from a query's one to many relation.
IE:
tblTest:

1 empty
1 empty
1 empty
2 empty
2 empty
2 empty
2 empty
3 empty
3 empty
4 empty
5 empty

If I bind tblTest to a form withour using group by, I'll be able to
change the records.
But if I choose groupby, it gives me "this record is not updatable".

What I'm trying to do is to group the 1, 2, 3, 4 and 5 items and
customer could choose to check a box or not (if item 1 is checked, the
3 empty records of tblTest would become yes.

Is it possible ,within a group by query, to bind a check box?
Thanks

 

[AY]

This is my assumption of your database

Table 1
Primary key field : has the records 1,2,3,4,5

Checkbox field: to accept yes or no

Table 2
Foreign key field : should be able to join Table 1 primary key field

If you were to join the 2 tables in a query and use criterial "Yes" on the
checkbox field, it should be able to filter only the checked records.

 

[magickarle]

This is my assumption of your database

Table 1
Primary key field : has the records 1,2,3,4,5

Checkbox field: to accept yes or no

Table 2
Foreign key field : should be able to join Table 1 primary key field

If you were to join the 2 tables in a query and use criterial "Yes" on the
checkbox field, it should be able to filter only the checked records.









- Show quoted text -

I don't have have PK in the table with checkmark.
Even if I had a PK, I couldn't use it the the relation (one to many)

 

[AY]

The checkbox field is not the PK field. The field containing the records
1,2,3,4,5 .. is the PK field.

When PK join FK in the (many table) and when the checked is selected eg 1,
it should only show records for 1 in the FK table. You must type "Yes" in the
criteria of the Checkbox field in the query.

 

[magickarle]

The checkbox field is not the PK field. The field containing the records
1,2,3,4,5 .. is the PK field.

When PK join FK in the (many table) and when the checked is selected eg 1,
it should only show records for 1 in the FK table. You must type "Yes" in the
criteria of the Checkbox field in the query.






- Show quoted text -

I think my problem is related to group by because without it, I'm able
to update the recordset.