This brings up another question: I have been building a table based on the contents of another table. I have been putting the fields I need from the base table into global variables and performing another script, which opens a new window, to add one record at a time. Very time-consuming. If I relate these tables, I could update the fields in the 2nd table directly from the first table, but there is no "write record" command to actually write the record. In my current design, it is closing the window that forces the "write". Do I indeed need to do what I am doing in this case to create the new records, or am I missing something again? Ron
-----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Ron Sent: Wednesday, December 10, 2008 11:14 AM To: [email protected] Subject: Re: Go To Related record 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"
