Unable to edit records returned by query

[EMount]

I am using access 2003.

I have a select query that works fine when I take all fields from one table. I am able to edit the records. When I add a field from a second table and run the query, it works but I can no longer edit the records. It does this even if I take all the criteria out.

The second table is only two fields, FullName and LoginName. It is joined to the first one on the FullName field.

Any idea what might be causing this?

Thanks,

Erica

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[EMount]

Thanks for the link. It was helpful. I managed to get query results I could edit by changing the field I linked on to the primary key in the second table.

This seems to have created another problem.

I won't go into it just now. I'm going to look at it a while longer and see if I can figure it out on my own. If not, I'll likely post again.

Thanks for all your help,

Erica