Something like this:

Table: categories
CatID
Category

Table: questions
QuestionID
CatID
Question

Then, for example, to select questions using the lookup:

SELECT mytable.*, categories.category, questions.question FROM mytable, categories, questions WHERE mytable.catID = categories.catID AND categories.catID = questions.catID

so do i create the query then when i add a lookup field, select the query to populate the field?

Sorry, I don't understand your last question. You'll need to create 2 lookup tables.  For each new category, you'll add 1 record (row) to the category table, and add 1 or more question records to the question table, each of the new records in the question table will have the same CATID as the new record in the category table.

Your non-lookup table will contain CATID, which you can use to lookup the list of questions by joining to the 2 lookup tables as in my example (or just join to the question table if you don't want the category name).

Were you looking for an update query?

What do you want your results to look like?

i want to create a new table lets call it Student, i want to add a field that is populated from the category table, i am using a Lookup & Relationship field type and populating with the category table.

I want to add another field for questions, but i want to populate it pulling questions from the question table where category matches the selection from the category dropdown.

I have the category and question table setup like you have above.  

When i select lookup & relationship i can select a table or query to populate, so i am guessing i need to create a query first then select it.

So, you have an interactive form of some sort, and the user selects a category and you want to display the questions for the category?  You would need to create a query that selects all questions where catID is equal to the studen't catID.

And if each student can have multiple questions, you would create another lookup table.. "StudentQuestions" which has only 2 fields, studentID and questionID.

So, they'd select a category, it runs a query grabbing all questions for the category, displays the list, the user selects 1 or more questions.One record is added to the StudentQuestions table per user selected question.

they only select one question, but yes they select a category, runs query and grabs all questions for that category, user selects one of the questions

The user selects a category.
Run query and display all questions for the category to the user.
User selects a question.
The selected QuestionID is stored in the student table.

i have attached a basic version of what i mean, if you open the student info table i want to add a field that populates questions depending on what was selected in the category field

so i enter student name, select a category, then the next field would let me select a question linked the categories just selected. Database1.accdb