Can I filter a value list in a related field?

Here is my situation:

In Database A, I have a database of students (Field: Full Name). For
each student, I indicate in another field (Field: Status), whether the
student is "Active" or "Not Active" (I made a value list with these two
custom values to choose from).

In Database B, I would like to be able to assign students to a test
using a related student field in the form of a check box set. I made
another field (Field: Students), whose values come from a value list
based on the "Full Name" field from Database A. All of the values show
up in the checkbox set. However, I only want to display the students
from Database A who have "Active" as their Status. Is there a way of
doing this?

Thanks
-Frank

.

Relevant Pages

  • RE: student groups, random, create more than once
    ... ChildAddress1 - text ... I want a behavior database. ... 12 classes and 30 students in each ...
    (microsoft.public.access.gettingstarted)
  • RE: student groups, random, create more than once
    ... one database rather than more than one. ... There is no overlap of students. ... The partner choice piece, I would like to do this no matter what... ... If you add another child or class this would mean ...
    (microsoft.public.access.gettingstarted)
  • Need help with ASP script.
    ... the beginning process of having a webpage that will direct students to ... I had downloaded a free ASP script which basically uses a ... 'Check the database to see if user exsits and read in there password ... 'Database connection info and driver ...
    (microsoft.public.inetserver.asp.general)
  • Re: tables in FM7
    ... > Bill wrote: ... The database designer sees the field definitions, ... >> can have many students. ...
    (comp.databases.filemaker)
  • Re: Using a fieldname as parameter value
    ... To find all the students enrolled in a specific class you'd ... > The data is stored in an Access 2003 database in Access 2000 format. ... > is gathered by a series of Access macros. ... >>> populate a list box with the names of queries by specifying a value ...
    (microsoft.public.access.queries)