Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsDatabasesMicrosoft Access Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old August 6th, 2004, 12:48 PM
TwlfthNght TwlfthNght is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Posts: 1 TwlfthNght User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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!!

Reply With Quote
  #2  
Old August 6th, 2004, 01:13 PM
ktrails ktrails is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2004
Posts: 5 ktrails User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft Access Development > Need help creating a new database


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT