records won't update

[one1george]

Hello,

I have one to many relationship set up.
when i build my form i am able to attach the related
tables to the form.

I can build a working queries using the tables.

my problem is that i can't input data into
the form attached to the tables. (the recordset is not
updateable ) is the error i get.

i checked the form and it is set to dynaset.
cascading updates doesn't seem to help .

any ideas.
thanks
robin

 

[John Vinson]

Hello,

I have one to many relationship set up.
when i build my form i am able to attach the related
tables to the form.

I can build a working queries using the tables.

my problem is that i can't input data into
the form attached to the tables. (the recordset is not
updateable ) is the error i get.

i checked the form and it is set to dynaset.
cascading updates doesn't seem to help .

Typically, you would NOT base the Form on a query linking the tables.
Instead you would use a Form based on the "one" side table, with a
Subform based on the "many".

It is important that each table has a Primary Key, and that you use
the Primary Key (or, rarely, another field with a unique Index) as the
Master Link field of the subform; the corresponding (non-unique)
foreign key would be the child link field.

John W. Vinson[MVP]
(no longer chatting for now)