M
Mel F
I don't know VB or SQL and I'm sure this would be so much easier if I did.
Here is what I have: 3 tables - category - question - answer (table was set
up this way before I took it over). They all have autonumber primary keys
that link them together so lets say category 1 has 4 questions under its
heading and each question has 4 answers.
I need a form that I can use to edit the answers on. I want to have a
listbox for category where I select the category, and the question listbox
fills in acording to the category, then I select a question and the answer
box fills in with the first available answer under that question heading. I
have been trying to figure this out for 6 hours and I'm at my wits end. Help!
Here is what I have: 3 tables - category - question - answer (table was set
up this way before I took it over). They all have autonumber primary keys
that link them together so lets say category 1 has 4 questions under its
heading and each question has 4 answers.
I need a form that I can use to edit the answers on. I want to have a
listbox for category where I select the category, and the question listbox
fills in acording to the category, then I select a question and the answer
box fills in with the first available answer under that question heading. I
have been trying to figure this out for 6 hours and I'm at my wits end. Help!