I need (if possible) the download trigger to automatically refresh the page with the updated DetailDownload - let me explain why.
My store also sells music books, so on my order details page I have 3 tables, each using its own recordset.
The first is 'music downloads (rsMusic)' and looks for items that have 'DetailCategory = 1 AND DetailDownloads < 1''
The second is 'music downloaded (rsDownloaded)' and looks for items that have 'DetailCategory = 1 AND DetailDownloads = 1'
The third is 'books (rsBooks)' and looks for items that has 'DetailCategory = 2'
So once someone has download the file, I would like the page to refresh with the item moving from table 1 to table 2 which has no download option…