HELP! Can't add new records with query??

[CatahoulaHound]

WHAT HAVE I DONE. I have been starring at this DB for hours. I have a query tied to two tables that was working fine until I started manually updating the tables with some old data. Now I get an error message that says that the recordset is not updateable?? Can somebody suggest someplace, anyplace, everyplace!! to look.
Thanks
Pat

 

[CatahoulaHound]

Can something I've done in another query be causing this or does it have to be something with the 2 attached tables??
Thanks
Pat

 

[Telsa]

When you updated the tables, are you using the query to update them??? Is your query an UPDATE query vs SELECT query?

Mary

 

[CatahoulaHound]

Telsa:
It is a Select query, but shouldn't I be able to add new records to the underlying tables in the query? I can in my backup copy so it must be something in the data that I put into the tables last night after I backed up the DB. It is "player info" and "family info" linked together in a query called "FamPlayerID" by the phone number. I'm lost so far.
Thanks In Advance
Pat

 

[NoteSmith]

There is a problem in your relationships somewhere. Most likely there is a Primary Key or a foreign key field that is not in the grid and should be, especially if you have are using an autonumber.

A way out of the mess is to rebuild your query one step at a time. Test the steps as you go along to make sure you can update data. When updating fails you will have a clue as to what part of the relationship is hanging you up.

 

[CatahoulaHound]

Thanks NoteSmith. I will start doing that now.
Pat

 

[CatahoulaHound]

You had it NoteSmith. I had 3 phone numbers wrong in the FamilyID table.
THANKS!!
Pat