Professional Web Applications Themes

Copy value from previous record? - FileMaker

I have a field set up with the auto-enter option "copy value from previous record". Exactly _which_ record is "previous"... the help file doesn't say. I guess I assumed it was the last one entered. When I create a new record in this file from a portal in another related file, I can't see any rhyme or reason to the value that gets put in here. Thanks, Steve...

  1. #1

    Default Copy value from previous record?

    I have a field set up with the auto-enter option "copy value from previous
    record". Exactly _which_ record is "previous"... the help file doesn't say. I
    guess I assumed it was the last one entered.

    When I create a new record in this file from a portal in another related
    file, I can't see any rhyme or reason to the value that gets put in here.

    Thanks,

    Steve

    Steve Guest

  2. #2

    Default Re: Copy value from previous record?

    Hi Steve

    The online help says "the previously accessed record" but this only seems to
    when you are working in the child file. My attempts to make it work via a
    new record made on the last portal row also failed. When I tried
    disallowing creation of new related records through the portal, and
    scripting it instead the auto-enter option worked, that is, it auto-entered
    the value from the last record accessed via the portal. Don't know why it
    should work one way and not the other. Here is how you script the creation
    of new related records:

    In the child file:

    New Record/Request
    Set Field [Foreign Key, Global Number Field]

    In the parent file:

    Set Field [Relationship::Global Number Field, Primary Key]
    Perform Script [Subscript, External (script in child file)]


    Bridget Eley

    in article [email]0001HW.BB56EAC40002615F09A92C60text.giganews.com[/email], Steve at
    [email]nospamnospam.com[/email] wrote on 7/8/03 7:26 AM:
    > I have a field set up with the auto-enter option "copy value from previous
    > record". Exactly _which_ record is "previous"... the help file doesn't say. I
    > guess I assumed it was the last one entered.
    >
    > When I create a new record in this file from a portal in another related
    > file, I can't see any rhyme or reason to the value that gets put in here.
    >
    > Thanks,
    >
    > Steve
    >
    Bridget Eley Guest

Similar Threads

  1. Record Set & Next | Previous Links
    By drdagwood in forum Coldfusion - Getting Started
    Replies: 0
    Last Post: October 14th, 12:08 AM
  2. Shadow Copy/Previous Versions Not Working
    By Maelstrom Maestro in forum Windows Server
    Replies: 0
    Last Post: June 25th, 08:45 AM
  3. Next and Previous record
    By Rick in forum PHP Development
    Replies: 5
    Last Post: November 9th, 04:45 PM
  4. Fill a field from the previous record
    By Bruce Rodtnick in forum Microsoft Access
    Replies: 3
    Last Post: August 1st, 11:11 PM
  5. previous favorites list copy comment
    By Tim in forum Windows XP/2000/ME
    Replies: 0
    Last Post: July 11th, 01:18 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139