Show only current values

[oscar23445]

I have a popup course id in student register. In this list it shows all the course id and otherthings that belong with that course id.

What i am trying to do not show the course id that are in the past in student register.

Or only show the classes that the roster submited yes box is unchecked

In Course schedule there is a check box that says (Roster Submitted Yes or No) I would like to use this to not show class once the check box has been check yes.

Here is what i have set up in relationship graph:

Students::Student ID = Student Register::StudentID //enable "Allow creation of records..." for Student Register here//

Course Schedule::CourseID = Student Register::CourseID //enable "Allow creation of records..." for Student Register here//

Course Schedule::ClassID = Classes::ClassID

If you go here you can see the Relationships and the popup that i am trying to not show past dates it is in another post that i have put up http://fmforums.com/forum/showtopic.php?tid/213715/

I hope this clear on what i am trying to do. Thanks for any help you can give

Thanks

Oscar