Table within Table

I have a database for a college that I am working on that has one table called programs. This contains the courses of study, required hours, etc. I have a second table that contains the individual courses. I want to make a field in the Programs table that lists the required courses pulling from the list of courses in the Courses table. I'm not sure where to start.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jadedataMS Access Systems CreatorCommented:
Hey! sgau1406,

You want to do this with a query.  Use the query design (wizard) to add tables and join those tables.
Select fields by dragging them into the query fields list.

How much have you used Access?


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sgau1406Author Commented:
I haven't messed with queries much. See one program of study contains many courses. But one course may be linked to two or more programs of study. I tried creating the relationship between the similar fields of both tables. Now the courses each have a course number, but the programs do not. Let me draw it out for you:

Table: Programs                                          Table: Courses
Program of study                                         Course number
Required Hours                                            Course Title
Description                                                   Description
*Required Courses*                                     ProgramRef

Each table of course has an autonumber. I've got everything else set up. I just want to have a report that will show the associated courses with each program.
you need a third table:


This lists for EACH single Program, the several Courses that are required

ProgramID is The Primary Key of the Program, CourseID is the primary Key of each Course

You can then easily list the Courses required for any program.

Select Program.[ProgramOfStudy], Course.CourseTitle from Program, ProgramReg , Course
Where ProgramReq.ProgramID = Program.ProgramID and ProgramReq.CourseID = Course.CourseID

and use this Query as the recordsource for a Report:

Program Of Study

Program Of Study

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.