recordset not updateable

[karassik]

I have two table which are linked via JOBID, then I have a query that pull different fields from the two tables.

The results of the query when edited gives me an error stating "Recordset not Updateable". Both tables are autonumbered, they are linked via "indeterminate", but I would think it to be a one to many.

Any thoughts?

 

[Darrylles]

Hiya,

Do you have a count within the query?

Look at the help for this error message, it gives you reasons for the error and will tell you about specific things that you can't do with a query (especially regarding relationships between tables).

Regard,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[karassik]

I figured it out...simple relationship issue of try in to combine a one to many with the one.

Thanks,

Nishan

Usually I end up getting help here or figure it out eventually.