I have a form with a drop down box (among many other fields) to select a record from. There is a good likelyhood the user will want/need to enter a new record into the drop down when they get to it. What is the best way to keep the information currently in the form while a new record is entered for the dropdown box? The ideal scenario would be to popup a new window with the dropdown form to add a new record. Once I click save, the record is inserted, the window closes, and the dropdown box on the parent form is refreshed and defaults to the newly created record. But that doesn't sound like an easy thing to do. What would you recommend?
