1 Reply Latest reply on Nov 24, 2008 3:40 PM by raybaudi

    relationship

    hopk87

      Title

      relationship

      Post

      I have built 2 databases and want to link them via zipcodes. But one database has 5 digit zip field but the other one has zip plus 4 . I cannot get the 2 to link. I have tried to reduce the zip + 4 but cannot get the field reduced

       

      Is there a way to get the 2 field to sync?

       

      Thanks

      Gary

        • 1. Re: relationship
          raybaudi
            

          Hi

           

          make a calculation field like this:

           

          Left ( zip+4 ; 5 )

           

          and make the relationship from this field and the zip field of the other table.

           

          Ofcourse the relationship will keep the first record having the reduced zip+4 code.