Select Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two fields Subject and Subtopic. I need to have the subtopic field
look up values in multiple tables based on the subject. For example, if
subject is "Benefits", then I need the Subtopic field to lookup the values in
the BenefitsList Table for selection; or if the Subject is "Background
Check", then I need the Subtopic field to lookup the values in the BGCList
Table for selection. There are 14 possible subjects with corresponding
subtopics.

How do I set this up in the TABLE and FORM for these two fields?
 
Hi Lesley,
I need to have the subtopic field look up values in multiple tables...
Click to expand...

Red flag. This is likely not a proper database design. I suggest, instead,
that you have a table of subjects, tblSubjects, and a table of subtopics,
tblSubtopics. Create a one-to-many (1:M) relationship between tblSubjects and
tblSubtopics. (You might possibly have a many-to-many (M:N) relationship as
well, if a given subtopic can apply to many subjects.

Check out some of the database design papers available here:

http://www.seattleaccess.org/
(See the last download titled "Understanding Normalization" in the
Meeting Downloads page)

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Back
Top