I have plant table that I am using for a lookup field in another application. My problem is that in the a plant can have an active record and a closed record. The lookup is pulling both plants. How can I only pull the active records. Yes, I have a field called "operative" in the plant table. Thanks for your assistance in advance.