Hi!
I have an easy one for you...because I have a brain fark!
I want to have my combox "remove" a question after it has been selected and the user moves to the next question.
I feel it would need to be based on two criterias. AARID is Null AND QID is null.
The two table I have are:
Questions table (20 questions)
Answers Table
Answer table contains the QID and AARID (after action review)
I was thinking it should be like this but I can't get this to work.
Any links? other threads I should check out?
Larry
I have an easy one for you...because I have a brain fark!
I want to have my combox "remove" a question after it has been selected and the user moves to the next question.
I feel it would need to be based on two criterias. AARID is Null AND QID is null.
The two table I have are:
Questions table (20 questions)
Answers Table
Answer table contains the QID and AARID (after action review)
I was thinking it should be like this but I can't get this to work.
Code:
Select * From Questions WHERE Not Exists( Select QID from Answers Where AARID = Me.AARID)
Any links? other threads I should check out?
Larry