You're absolutely right, there was no reason to GTRR. I think I have been wasting a lot of time in my conversion scripts...
"The light dawns over Marble Head..." Ron -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Jason L DeLooze Sent: Wednesday, December 10, 2008 10:56 AM To: [email protected] Subject: Re: Go To Related record On 12/10/08 at 10:35 AM -0500, Ron wrote: > As part of a conversion I need to update one field from a field in a related record. > If I write a script to read the table that needs updating, then go to related record to get the field, it seems to me that the focus has changed to the related record's layout and I can't then get back to the original record to update it. > I need to read the base table thru one by one to update this field in all records. > Can anyone steer me in the right direction for this? > Many thanks! > Ron Carr Ron, Not certain why you must go to a layout based on the related table (TO) just to get the field's value, but let's assume you do need to. In this case, whenever you GTRR to the related records, use the "Show in new window" option (and name this window), do your related records work, Close this Window to return to your original window with the Parent's record, and continue with the work on the Parent's record. By opening a new window in the GTRR, you leave the original window undisturbed - keeping everything as if you never left the Parent's layout, etc. Best wishes, Jason L. DeLooze Annapolis, MD USA "You must be the change you want to see in the world"
