Select values from available options (1 Viewer)

[Chrism2]

I don't normally get too many challenges with tables, but I'm struggling here, and as far as I figure it, it should be possible without forms or vba.

On the (attached) DB, I have a series of tables for tracking training courses.

- The main table is [tblCourses]

- Every course has a "Course Type" - a list from [tblCourseTypes].

- Every course can comprise of one or more elements (think "activities") - a full list is in [tblAllCourseElements]

- However, each CourseType has a set group of *possible* activities that can be chosen from. [tblPosCourseElements] shows the types of Elements by each Course Type.

- In the collapsing table from [tblCourse], we have the *actual* course elements; stored in the table [tblActCourseElements].

Here's the nut: I want the lookup field [elementID] in [tblActCourseElements] to allow selection *only* of elements that are available according to the [coursetypeID] selected in [tblcourses]

I really hope this makes sense to someone out there. As always - your assistance, much appreciated.

 

[Chrism2]

Ah. I see.

That's an informative link, Bob. Cheers.