I have a script that is assigned to a button. When this button is clicked, a new window pops up, displaying data from another table within the same FM7 file.

How can I limit the number of windows that this script will open?

The issue I'm having is that the user will open this new window via the script, and then go back to what they were previously doing. They forget that they already have that window open, so they click on that button again, and now there are 2 windows open. And they really get frustrated if they can't modify any records because they never finished modifying the first window.

Does anybody know of a way to make the script check for any windows that have the same name and select that windows before opening a new one?

Have an "If" condition in your script - "PatternCount ( WindowNames ) ; "Your open window title" ), that will see if there's a window with the title of your open window. If so, have it select it, if not, open a new window.