Cannot add record to query

[GREABR]

I am not sure what is happening here. When I try to add a record to a query, I get an error:

"Invalid Object Name 'LA'."

I have created some very simple tables and a query for troubleshooting purposes and continue to get this message. Here is how I re-create the message:

tblParent
ID
Number
(ID is Primary Key)

tblChild
Number
Description
(Number is Primary Key)

I create a query called TestParentChild with all records from tblParent, and Description from tblChild.
(all records from tblParent)

I add a record to tblChild (for the lookup):
Number = 1234
Description = Test

I open the query and add a record:
ID = New
Number = 1234


I cannot add this record - I get an Message box with the name of the project in the title bar, and the message stated above with an "OK" button.

My Access Project/Database is called "LA-DUMP IMS", that may be where the 'LA' comes from.

This Access Project was originally developed on a laptop with Access 2000 and an MSDE Database. Recently I have moved the project to a Network, backed-up from MSDE and restored to SQL Server, upgraded the project to Access 2002. I have had a couple of small problems - things that worked ok on the laptop and did not work after moving the project. (this problem included)

Any Ideas?


"Don't be afraid to do things wrong, before you do them right"
Bradley Greaves