Newbie Access 2007 Query Question

[MattGreer]

I used to know Access 2002 pretty well, but apparently I've forgotten everything!

I'm making a database for car maintenance and data. I'm entering things like mileage and costs and so forth.

I created a query to pull the records out of the main table, called 'MainData'. When I run the query, (just a select query) I have no problems adding a new record.

I then decided to create another table called 'Cars', to contain the names of the different cars I own in that table, and then pull the ID number of the car over to the main table. I added that table to the query and modified the query to display the CarName rather than the CarID.

Whenever I run the query and try to add a record, I get the error "Cannot add record(s); join key of table 'MainData' not in recordset". I only get that error when I try to enter information into the cell that is NOT connected to the other table.

What am I doing wrong?

Thanks!!


Matt

 

[MattGreer]

Bah, figured it out. The join type was set to where the data on either side of the join was equal. I needed to have set it to where all records from MainData were included. Heh.



Thanks!!


Matt