I have a database, I pull a current records list of a group of things.

My question is when I pull this and open a new window to show the list.

I have a button to take me to the layout for more information on the record. But it continues to leave the extra window on the screen.

If I close the screen in the script it takes me back to a record that I was on when I pulled the list.

Is there a way to create a button to select the record in the open window then close the window on the selected window and that record be in the window that i pulled the list with.

Thanks in advance. I hope I have explained it well enough.

You want the button to be attached to a script that:

grabs the ID for the "thing" in a variable

closes the popup window

enters find mode in the original window

finds the ID

Depending on how the popup window is handled (e.g. if it's modal/nonmodal) you may need to perform extra work - if it's possible for user to go back to the original window and monkey with things, in other words, then you can't depend on the current layout to perform your find in. And if your popup is displayed in the middle of a larger script, then you'll need to exit that script gracefully, either by controlling it via the Button options, or using Exit Script [Result].

In any case:

Set Variable [$ThingID; myTable::ThingID]

Close Window [myPopupWindow]

Select Window [myOriginalWindow] //if it's possible to have more than 2 floating around

Enter Find Mode

Set Field [myTable::ThingID; $ThingID]

Perform Find

I thought of that on finding in the original window, and I like the way you set that up, but is there a way even on just using related record function to get the same thing.

?

Just asking

Given a single-file solution, Go to Related Record can point to a New Window, or the Current Window, but not another existing window.

It would be nice if it could, wouldn't it?