Return to FileMaker.com
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?
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.
Retrieving data ...