Professional Web Applications Themes

Duplicate records? - FileMaker

Hi Shai Use field validation to ensure that entries are unique, with a custom message to tell the user what to do if they aren't. Bridget Eley in article newscache$zgcnih$rb$1lnews.actcom.co.il, shai Ben Mordechai (Rosenblum) at [email]glaactcom.co.il[/email] wrote on 27/7/03 6:22 AM: > Hi all, > Using Windows XP, FMP 6. > What is the best method for entry new record, search for duplications and > have a message regarding what to do next ?(delete, add) > TIA > > Shai...

  1. #1

    Default Re: Duplicate records?

    Hi Shai

    Use field validation to ensure that entries are unique, with a custom
    message to tell the user what to do if they aren't.

    Bridget Eley



    in article newscache$zgcnih$rb$1lnews.actcom.co.il, shai Ben Mordechai
    (Rosenblum) at [email]glaactcom.co.il[/email] wrote on 27/7/03 6:22 AM:
    > Hi all,
    > Using Windows XP, FMP 6.
    > What is the best method for entry new record, search for duplications and
    > have a message regarding what to do next ?(delete, add)
    > TIA
    >
    > Shai
    Bridget Eley Guest

  2. #2

    Default Re: Duplicate records?

    Bridget,
    yeap... I know that I can define the last and first name as concatenation
    and make it unique. But... Sometime people have the same last name and first
    name...

    TIA

    Shai


    shai Ben Mordechai \(Rosenblum\) Guest

  3. #3

    Default Re: Duplicate records?

    > Using Windows XP, FMP 6.
    > What is the best method for entry new record, search for duplications and
    > have a message regarding what to do next ?(delete, add)

    I would give each record a Client ID Number and use the auto create and
    validate function.

    If some one else enters a record with the same details.. I would have a
    list view and with sort by name, rank and serial number as well as a Go,
    Omit and delete button... This way it is very quick and easy to see if two
    records are the same, and to delete one if it is...

    To see if the deatils of a record is a duplicate of another you would have
    to search all fields... no spelling mistakes... and if record has more data
    than the other it will not be found.

    You could make a script that copies the details of a found record in browse
    mode, switches to find mode then paste the data and perfom find.... (you
    shouldn't need any error capturing as it will always find the one record...

    but if there are duplicates of the data entered it will be found. But again
    if one record has more data than the other or has a spelling mistake or
    data is entered wrong, etc... it won't be found.

    As I said the easiest and most logical way for find duplicates is making a
    list mode report with your buttons... (But thats just me... and works well
    for me)

    --
    ----------------------------------------
    Quantum Illusions: [url]http://quantum.2ya.com[/url]
    Pegasus Mail Support Site: [url]http://pegasus.quantum.2ya.com[/url]
    Freeware Site: [url]http://freeware.quantum.2ya.com[/url]
    DATA Solutions: [url]http://datasolutions.quantum.2ya.com[/url]

    If you truly want to contact me click the link
    [url]http://quantum.2ya.com/email.htm[/url]

    Bebop & Rocksteady Guest

Similar Threads

  1. Duplicate records
    By DuLaus in forum Coldfusion - Advanced Techniques
    Replies: 7
    Last Post: October 25th, 03:20 PM
  2. Return Records and not duplicate them :: Again
    By The Ox in forum Dreamweaver AppDev
    Replies: 1
    Last Post: March 16th, 05:57 PM
  3. select all the duplicate records
    By atse in forum ASP
    Replies: 9
    Last Post: October 19th, 06:59 PM
  4. Deleting duplicate records
    By Dinesh.T.K in forum FileMaker
    Replies: 3
    Last Post: August 13th, 12:00 AM
  5. Need help serializing duplicate records
    By Scott in forum FileMaker
    Replies: 2
    Last Post: July 30th, 06:24 PM

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