Hello folks... I'm new here and have just started to go through this site...

I have a solution I'm making for my own CPR biz right now. What I'm trying to do is this.. My course records table contains a course #. This course number is entered in a spot for each student we have.

Also in the course table I have an option that states if everything has been completed with the course choose yes. Based off of another compnay's design what that is suppose to do is prevent that particular class to show up in the drop down list of available courses over on the student side of things.

I can not figure out how to make that happen. I've done a search for that class along with omitting the other class. This just isn't working. I'm sure this is stupidly simple and I'm so frustrated that I'm not thinking clearly enough to figure it out...

Thanks in advance for the help!

This is often called a "dwindling value list." But it is not stupidly simple; it is not even simple. I don't know about the "yes" business though. I would think it should filter out already chosen courses before they click "yes," unless you're using that to run a script to create the course-student line items records (doubtful).

Personally I find these "yes/no" things to often be superfluous, only really useful in a "lock" situation, where it really has some meaning. In that case it would just be a number field, with a Boolean result. It's either 1 or it ain't nuthn'. Why have a "No" choice, when it is no different from no choice at all? Why have a "yes" choice, when a simple 1 would do (and is a heck of lot easier to do things with)? I've seen so much data (of others) which had data entered, but someone forgot to click the "yes", or visa versa; not only superfluous, but unreliable.

Edited June 22, 200817 yr by Guest

Thanks for the reply...

All the "yes/no" is for would be a visual to know that course was completed and also for a "filter" for that drop down list of available courses.