Professional Web Applications Themes

Two files get zip codes??? - FileMaker

Using Filemaker 5.0 on PC. I have two files, each containing contacts with addresses and zip codes. I would like to find all of the zip codes in Table A that are not in Table B. I can not figure out how to accomplish this. Any help will be appreciated. If your muslins are not ONTRAX, you are working too hard. Ontrax systems [url]http://www.ontrax.com[/url]...

  1. #1

    Default Two files get zip codes???

    Using Filemaker 5.0 on PC.

    I have two files, each containing contacts with addresses and zip
    codes. I would like to find all of the zip codes in Table A that are
    not in Table B. I can not figure out how to accomplish this. Any help
    will be appreciated.
    If your muslins are not ONTRAX, you are working too hard.
    Ontrax systems [url]http://www.ontrax.com[/url]
    Ed Burns Guest

  2. #2

    Default Re: Two files get zip codes???

    So you have two tables, each with a zip code field...

    Table A::
    Zip Code Field

    Table B::
    Zip Code Field


    And you want to find all of the records in Table A that are not in Table B?


    Make a relationship from Table A to Table B with Zip Code as the key
    field...

    Table A::Zip Code = Table B::Zip Code

    Now make a layout in Table A. Place both fields on the layout.

    Do a find with the criteria...

    Table B::Zip Code = *

    Check the "Omit" box

    Your result will be what you want...

    All the records in Table A that do not have a related record in Table B


    I hope this helps,

    Matt Revenaugh

    - - - - - - - - - - - -


    On 7/29/03 1:09 PM, in article [email]dvkdiv8a12rdeqv9l6mdo41v2mmfq30hiu4ax.com[/email],
    "Ed Burns" <edburnsontrax.com> wrote:
    > Using Filemaker 5.0 on PC.
    >
    > I have two files, each containing contacts with addresses and zip
    > codes. I would like to find all of the zip codes in Table A that are
    > not in Table B. I can not figure out how to accomplish this. Any help
    > will be appreciated.
    > If your muslins are not ONTRAX, you are working too hard.
    > Ontrax systems [url]http://www.ontrax.com[/url]
    Matt Revenaugh Guest

Similar Threads

  1. Question how to write cfm codes
    By Chitra Devi in forum Macromedia ColdFusion
    Replies: 0
    Last Post: April 13th, 06:59 AM
  2. Configure IIS to process cfm codes in html files
    By G-Tiger in forum Coldfusion Server Administration
    Replies: 2
    Last Post: November 18th, 07:37 PM
  3. Need help finishing codes
    By mytime30 in forum Coldfusion Flash Integration
    Replies: 0
    Last Post: April 17th, 04:14 AM
  4. Locale-Codes 2.07
    By Neil Bowers in forum PERL Modules
    Replies: 0
    Last Post: June 11th, 09:42 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