Help!! I have beat my head up against the wall repeatedly and come back to this over a period of months to no avail.
I have a dropdown list in SQL that is based on a join between a table of items in a catalogue and items that have been ordered. There is only one of each item.
My problem is that when a user is logged in, and selects an item from the drop down of available items and saves their selection, if they reopen that add item screen, that item continues to appear available in their drop down even though the selection if it has been recorded into the database. The only way to get the item to disappear from the drop down is to close that browser window (refresh or log out is not sufficient) and log in to a new browser window.
Is there a piece of code I can place on the AddOnLoad event that will refresh that list completely?
Sample:
Drop Down:
Apple
Orange
Banana
Grape
User completes and order of Grapes.
When they return to the add item screen, Grapes should no longer appear, but this decrement only occurs with a complete shutdown of the browser window.
Thanks!!