you could create a relationsship where you connect the table to a TO of itself and define that the field "active" is valid.
Then create a dropdown list based on this relationship. It will only show the records "active".
Thanks. Sounds logical.....However I am a newbee...."TO" What is it and how do I create it?