Basic combo box in form

[angiemeh]

I'm learning access and have read blogs, books etc. I'm getting better, but I'm stuck on something and I think it should be easy.

I have an Item table with Item#, Item Desc, Qty of Sugar, Country.(I just added the Country field because it was not in the table before, so all country fields are currently blank)

I have another table with just the Unique Countries. I made the relationship between Country to Country in both tables and chose the join= "Include ALL records from 'Item Data' and only those records from 'Country Codes' where the joined fields are equal."

Each item can be made in a different country. I used the wizard to create the form with Item#, Desc, Qty of Sugar and Country. I wanted Country to be a drop -down when the user went to fill in the data. So, I made a combo box and my row source is
SELECT [Country Codes].[Country] FROM [Country Codes] ORDER BY [Country];

When I go to fill out the form in datasheet view, I see current items already there. When I click on the Country field, I get a dropdown of countries and I choose one, but it changes ALL the country fields to that value instead of just that row.

I want to be able to go into a current row and add a country for JUST that item, and then a different country for the next etc...

What am I doing wrong?

 

[angiemeh]

Also, I noticed that my item field is now a dropdown and the drop down is country. I didn't do anything to the item field....