Here's what I'm trying to do. It's a bit complex, so bear with me here.
I have a table (Interpreters) which contains names, addresses, phone numbers, etc., another table which contains the schedule of the interpreters, and another table that contains the assignments the interpreters are to be scheduled on.
What I want to do is to be able to select all of the records in the interpreters table, filter them by availabiltiy and display them in a list on the schedule form. This will allow the users to see which interpreters are available and their contact information. Thing is, I can't even figure out how to get the interpreters names displayed as a list, excepting with a list box. The list box doesn't allow me to modify the interpreter's table with a contacted y/n or declined y/n, though, so that won't work either.
I'm looking for more broad, general solutions here, so don't worry too much about the specifics.