Insert record then go to URL from Data Source

[Roger_Angus]

Maybe there's an easier way to do this but I have a dynamic table generated from search results. One column in the table displays links to files to download using <?php echo $row_rsResultsMusical['SHORT']; ?> attached to text. SHORT contains the URL of the file.

What I need to is keep track of who is downloading what. To this end I've created a form with hidden fields containing all the info i need and I'm using the insert record server behaviour. My problem is that once the form is submitted, I want the browser to go to the url of the file the user wants. I've tried using the 'after inserting go to' browser to specify the SHORT data source and dreamweaver which shows as <?php echo $row_rsResultsMusical['SHORT']; ?> in the dynamic data window, then as " . $row_rsResultsMusical['SHORT'] . " in the insert record window.

Clicking on the button returns a dynamic table with all results.

Am I doing something totaly wrong here? is there an easier way to record who downloads what?

Thanks.

[Roger_Angus]

I'm still stuck with this. I've attached a onlick open browser window behaviour to the submit button so a window pops up with the download after the details have been written to the DB. This is great but then I need the main window to remain unchanged, right now it changes to display all results.

I'm struggling here, what is the most elegant way to log which user is downloading what?