Constraining a pop list via a script?

[cpfeiler]

Hi,

For the sake of simplicity my problem is that I want a "forced" lookup to find a specific record in version (7). What I am trying to accomplish is to complete a find from the results of 2 pop-up lists. But I want to constrain the second pop-up list to be the results of the first. For example - the first pop up list is all the last names in the database. Once I select a last name - I would like the second list to only display the appropriate first names. I thought to have the first list force a find, figuring that the constrained find would force the second pop-up to list only the first names from the find - but I do not seem to be able to make this happen.

thanks,

cathy

[-Queue-]

You want a conditional value list. See attached for a sample.

Cvl.zip

[cpfeiler]

Thank you very much for your help. I was at a lost - since I also have an id number set equal to itself - so I can "find" all the kids in 1 family. Yet there was more than 1 family with the same last name..........

cathy