I am building a survey type database. Many customer service tickets with about 17 question per ticket. I have read about junction tables but I don't understand how the 17 questions get into the junction table. I know I can choose them from a combo box, but I would much rather they simply show up. Help?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS Access table relationship question 1
- Thread starter seniram
- Start date
Consider reviewing At Your Survey which uses an append query to make questions "simply show up".
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
-
1
- #3
seniram,
Welcome to Tek-Tips. It's a great place to get help. One thing to keep in mind to get the best answers is to post your question in the most appropriate forum. Being as you're new, you probably don't know the forums right off.
Best way to find what you need is to search for them - type a keyword or two, and make sure that "Find a Form" is selected, and search. It should give you the most accurate results. If you're ever not sure, just go ahead and make your best guess.
Here is a FAQ that tells more detail about how to get the best answers to your questions at Tek-Tips:
faq20-2883
Also, for this specific question, being you're dealing with Access Tables, I'd suggest you post in the following forum:
forum700
And really quick for now on your question so far:
As far as how to get the data into the tables, that depends. It can be done via Form recordsets, VBA, and/or Queries.
But if you want to get more help, check out the FAQ link I posted, and then post possibly a better formed question over in the correct forum.![[smile]](/data/assets/smilies/smile.gif "[smile] [smile]")
--
"If to err is human, then I must be some kind of human!" -Me
Welcome to Tek-Tips. It's a great place to get help. One thing to keep in mind to get the best answers is to post your question in the most appropriate forum. Being as you're new, you probably don't know the forums right off.
Best way to find what you need is to search for them - type a keyword or two, and make sure that "Find a Form" is selected, and search. It should give you the most accurate results. If you're ever not sure, just go ahead and make your best guess.
Here is a FAQ that tells more detail about how to get the best answers to your questions at Tek-Tips:
faq20-2883
Also, for this specific question, being you're dealing with Access Tables, I'd suggest you post in the following forum:
forum700
And really quick for now on your question so far:
As far as how to get the data into the tables, that depends. It can be done via Form recordsets, VBA, and/or Queries.
But if you want to get more help, check out the FAQ link I posted, and then post possibly a better formed question over in the correct forum.
--
"If to err is human, then I must be some kind of human!" -Me
- Status