|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Need help creating a new database
I'm trying to create a new database in Access 2002, and it's been so long since I've used it that I need some help. Basically I have a list of questions that I need to categorize by both a characteristic related to them and a topic title. (Multiple questions can have the same topic title, and multiple questions can be linked to the same characteristic.) I would like to create a form so that all users have to do is enter in either the characteristic or the topic title (or both) that they are looking for questions related to, and up will pop a list of the questions that relate to the info they entered. Is this possible? What is the easiest way to go about it? Any help would be greatly appreciated. Thank you!!
|
|
#2
|
|||
|
|||
|
So create some tables:
Characteristics Id (key) Display text (text) TopicTitles Id (key) Display text (text) Questions Id (key) Display text (text) QuestionCharacteristics QuestionId (foreign key) CharacteristicId (foreign key) (make the combination of the above a compound key) QuestionTopics QuestionId (foreign key) TopicId (foreign key) (make the combination of the above a compound key) Have your form allow you to select a Characteristic from a list, and also a Topic from a list. Build your queries and go from there... probably lots of ways to skin the cat, but that should get you started one way at least... -jeff |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Need help creating a new database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|