I'm building a system that assigns instructors to classes. I have built a master/detail form that shows the class to be assigned and the possible instructors based on certain selection criteria. I want to the system to automatically select the possible instructors and display them in the detail block for the user to select to make the appropriate selection and then input the instructor id into the class record. What do I need to do? I know it involves some kind of trigger but I'm not sure which trigger to use. Do I have to build a cursor to be able to do the selection query? Any and all help will be much appreciated.