You can certainly create the opportunity using a trigger but you cannot navigate the user to another record from a trigger. Here are a few options: 1. Use "visual force" and "retURL" or "saveURL" in order to take you to the opportunity record 2. Override "edit" of "File_Note__c" with a visual force page and manage the logic that you mention in the controller extension. More info ...



