dbTalk Databases Forums  

Insert from last visited

comp.databases.filemaker comp.databases.filemaker


Discuss Insert from last visited in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
vcirilli
 
Posts: n/a

Default Insert from last visited - 11-10-2005 , 07:32 PM






Hi All,
The short version - is there a way to update the reference to "Last
Visited" via a script step.

Details:
I have a new record script in my data base. Basically it's function is
to create a new record and fill in
the appropriate fields to my specs. Some fields need to have the same
info inserted from the last record, others get calculated results
determined elsewhere.
For the fields that need the same info transfered I use insert from
last visited script step.
The Bug:
If the user creates a new record but doesn't edit or enter a field in
this record, then creates another record, the insert from last visited
step references the wrong data. (Whatever the last edited record was)
I need a way in my script to update the reference to - last visited
without the user having to enter or edit a record.

Thanks
Vincent


Reply With Quote
  #2  
Old   
Dan Fretwell
 
Posts: n/a

Default Re: Insert from last visited - 11-11-2005 , 09:06 AM






I am not absolutely certain what is going wrong. If you want to make
the new record active at some point so that it then becomes the new
target for last visited you can do it by a go to field script step. If
you want the older record to stay the target for last visited then you
must ensure that the record is not made active (other than by a user
editing a field of course). I believe, from my reading of the help
file, that Insert from last record will make the record active
(particularly if you check the go to field option).

If you have version 8 then you should consider the option of using
GetNthRecord as an alternative.


Reply With Quote
  #3  
Old   
vcirilli
 
Posts: n/a

Default Re: Insert from last visited - 11-11-2005 , 12:42 PM



Thanks Dan
I was using your suggestions.
Error on my part.
I had the step in the wrong place.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.