How to establish and/or relationships within a table?

[wes228]

I have a table of courses our university offers along with what restrictions are placed on them. The table has the Course ID as the primary key, and then the field is Restriction. For the sake of the example, I'll use the course names instead of their ID #s:



Course Name Restriction
Acting II Acting I
Acting II Fundamentals of Acting
Acting II No Freshmen

How can I incorporate the following logic into this table:

You must take either Acting I OR Fundamentals of Acting before taking Acting II AND you must not be a freshman.


NOTE That this table is in a "one to many" relationship with the course inventory table. One course may be associated with many restrictions.

[June7]

The 'relationship' is established between these tables on the CourseID fields. Use VBA code to validate user selection of a course. Can also use queries and code to limit user choices presented in combobox lists. Review http://datapigtechnologies.com/flash...combobox2.html