Updating Record with form help

[Treefarn]

I am VERY new to Access, and my guess is this question is fairly easy.

Here are my tables
Question Table
ID
Question
AnswerID
CategoryID

Answer Table
ID
Answer

Category Table
ID
Category


So my form shows :
Question, Answer, Category

And I can display any existing question and make updates to the question and answer, that works fine. BUT, what I want to do is update which category a question is in. If I change the Category in the form, it updates the 'Category' in the Category table. What I want it to do is update the CategoryID in the question table.

 

[Treefarn]

I actually found another thread after I posted. I'm not sure I understand the why yet, but this fixed my problem.

I actually can't post links yet, but it was thread 112624.

"To be able to post links or images your post count must be 10 or greater. You currently have 1 posts."

 

[Privateer]

For clarity, edit the primary key field names. The ID in Answers would work better if you called it AnswersID; same with questions and category. The quick answer to your problem is that you need to change the Answers and Category text boxes on the form to combo boxes. The row source for the combos is the tables, but you store the ID number in the Question table. The combo boxes will have two columns, the ID and Value, and the bound column is the ID. So the question table will get just the number.