Professional Web Applications Themes

duplicate this! - Microsoft Access

I have a form with three fields to enter a name (Adult1,adult2 etc). I can make no duplicates in one of the fields but I need to make sure a name isn't entered twice regardless of adult1,adult2 etc. Basically how do i Index all three at once?...

  1. #1

    Default duplicate this!

    I have a form with three fields to enter a name
    (Adult1,adult2 etc).
    I can make no duplicates in one of the fields but I need
    to make sure a name isn't entered twice regardless of
    adult1,adult2 etc.

    Basically how do i Index all three at once?
    michael Guest

  2. #2

    Default Re: duplicate this!

    There is a very easy solution.

    Instead of using repeating fields within your table, create a related table.
    The new table with have a one-to-many relationship with the first table,
    i.e. there can be many adults in the new table related to one record in the
    existing table.

    Since all the adults are not in one field, you can place a unique index on
    that field ("Yes: No Duplicates" in the lower pane in table design).

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
    Reply to the newsgroup. (Email address has spurious "_SpamTrap")

    "michael" <nnyy.com> wrote in message
    news:083401c34b4b$70748260$a101280aphx.gbl...
    > I have a form with three fields to enter a name
    > (Adult1,adult2 etc).
    > I can make no duplicates in one of the fields but I need
    > to make sure a name isn't entered twice regardless of
    > adult1,adult2 etc.
    >
    > Basically how do i Index all three at once?

    Allen Browne Guest

  3. #3

    Default Re: duplicate this!

    On Tue, 15 Jul 2003 20:36:27 -0700, "michael" <nnyy.com> wrote:
    >I can make no duplicates in one of the fields but I need
    >to make sure a name isn't entered twice regardless of
    >adult1,adult2 etc.
    In addition to Allen's comments, consider the fact that names ARE NOT
    UNIQUE. I used to work with Dr. Lawrence David Wise, and his colleague
    Dr. Lawrence David Wise. Larry was tall, blond and outgoing; L. David
    was stocky, dark and taciturn. You may be setting yourself up for a
    problem!

    John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
    [url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]
    John Vinson Guest

  4. #4

    Default Re: duplicate this!

    Great idea however I need the the form to beeb the person
    doing the intke to be told when they enter BOB Smith into
    the form that he already exsists. how can I do that - is
    ther some way for the form to check the all the feilds or
    the new table table that that name already exsists?
    >-----Original Message-----
    >There is a very easy solution.
    >
    >Instead of using repeating fields within your table,
    create a related table.
    >The new table with have a one-to-many relationship with
    the first table,
    >i.e. there can be many adults in the new table related to
    one record in the
    >existing table.
    >
    >Since all the adults are not in one field, you can place
    a unique index on
    >that field ("Yes: No Duplicates" in the lower pane in
    table design).
    >
    >--
    >Allen Browne - Microsoft MVP. Perth, Western Australia.
    >Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
    >Reply to the newsgroup. (Email address has
    spurious "_SpamTrap")
    >
    >"michael" <nnyy.com> wrote in message
    >news:083401c34b4b$70748260$a101280aphx.gbl...
    >> I have a form with three fields to enter a name
    >> (Adult1,adult2 etc).
    >> I can make no duplicates in one of the fields but I need
    >> to make sure a name isn't entered twice regardless of
    >> adult1,adult2 etc.
    >>
    >> Basically how do i Index all three at once?
    >
    >
    >.
    >
    michael Guest

Similar Threads

  1. Select DIV and duplicate it
    By naked_ollie in forum Macromedia Contribute General Discussion
    Replies: 2
    Last Post: August 10th, 12:02 PM
  2. Duplicate IP's and AOL
    By Joe_Krako in forum Macromedia ColdFusion
    Replies: 2
    Last Post: May 24th, 01:24 PM
  3. duplicate a w3d
    By Jimmy in forum Macromedia Director 3D
    Replies: 4
    Last Post: October 28th, 10:41 PM
  4. Duplicate Namespaces
    By Garret in forum ASP.NET Web Services
    Replies: 0
    Last Post: August 25th, 12:51 PM
  5. duplicate removal
    By john62@electronmail.com in forum PERL Miscellaneous
    Replies: 5
    Last Post: July 15th, 06:53 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