Creating a course schedule based on pre-req's

[MageNiema]

Hello,



I am wanting to create a database through access that can help me determine what college classes I can take based on the pre-req's. So I would want the database to see what classes I have already taken, and only show me classes I can take based on the pre-req's I have completed.

How would I go about doing this?

[ranman256]

tClasses table
------
classID (auto)
className
Completed (yes/no) 'if you have taken this class


tPreReqs table
------
classID (long) 'the class you want to take
PreReqID (long) 'the class that is a preReq for the class above


a query would join the 2 to show what youve taken.
an OUTER Join: tClasses.classID to tPreReqs.classID
set : all classes in tClasses, some in tPreReqs