I have a parent record of Names and a child table of Contacts for those folks. I also have a related data masterfile for contacts so I can track which contacts are active. I have been trying to create a table occurence using a global in the Names Parent set to Active which relates to the "Active" field in the master, if the contact is active the field is set to active. I am trying to use this to to make the drop down list of contacts show only the active. I have used the debugger to show the values of the global and the value in the child db, and they seem correct, yet the drop keeps retrieveing the active and non-active contacts. I am missing something fundamental, but don't know what it is. Thanks in advance.

I've done something similar by creating a calculation field "Status" and using it as the valuelist dropdown. If the status isn't active it doesn't appear on the list.

If ( Status = "Active"; Name; "")