We have a list of clients on a table. That table has 'Active' and 'Inactive' radio boxes, this indicates if the client even attends our program anymore or not so it is very important. On that same form/table we have a list of days Monday through Friday in checkbox form.  We have another form and table that we track attendance on. I would like to do 2 things, but would be happy with just one for now.

I our attendance doc is to be done daily by our staff and volunteers. The attendance doc has simply 2 fields, the date and a dynamically loaded multiple choice checkbox list of our clients by the name field. I need this list to display ONLY the clients that are marked in their file under the status as Active.

In my dreamworld I would like the very same list of names to load dynamically based on both the status field and the days of attendance. But for starters I would be happy with simply displaying the clients that are active.