I have 2 files with FM5.5 and want to import them into my new 8.5
version. The first file is my contact list with names, addresses,
etc. However, it does not have an associated county name. My second
file is a city/county lookup file that is related to my first file
such that when I put the city in, the county is then looked up. Under
5.5 it works fine. However, when I import to 8.5, it doesn't work.

Now, here is the strange part. If I manually enter a new city/county
record, and then type in the city in the contact file, the lookup
works and the county appears. But it doesn't work for any of the city/
county records that I imported.

Any thoughts?

In article <1186008170.974073.254040 [at] i13g2000prf.googlegroups.com>,
"Daniel G. Emilio" <dgelaw [at] gmail.com> wrote:

> I have 2 files with FM5.5 and want to import them into my new 8.5
> version. The first file is my contact list with names, addresses,
> etc. However, it does not have an associated county name. My second
> file is a city/county lookup file that is related to my first file
> such that when I put the city in, the county is then looked up. Under
> 5.5 it works fine. However, when I import to 8.5, it doesn't work.
>
> Now, here is the strange part. If I manually enter a new city/county
> record, and then type in the city in the contact file, the lookup
> works and the county appears. But it doesn't work for any of the city/
> county records that I imported.
>
> Any thoughts?

I presume the "lookup" works on the basis of a relationship. It would
help to diagnose the trouble if you would describe the relationship
structure and the give the definition of the fields involved.

--
For email, change <fake> to <earthlink>
Bill Collins

On Aug 2, 1:22 pm, Bill <bbcoll... [at] fake.net> wrote:
> In article <1186008170.974073.254... [at] i13g2000prf.googlegroups.com>,
> "Daniel G. Emilio" <dge... [at] gmail.com> wrote:
>
> > I have 2 files with FM5.5 and want to import them into my new 8.5
> > version. The first file is my contact list with names, addresses,
> > etc. However, it does not have an associated county name. My second
> > file is a city/county lookup file that is related to my first file
> > such that when I put the city in, the county is then looked up. Under
> > 5.5 it works fine. However, when I import to 8.5, it doesn't work.
>
> > Now, here is the strange part. If I manually enter a new city/county
> > record, and then type in the city in the contact file, the lookup
> > works and the county appears. But it doesn't work for any of the city/
> > county records that I imported.
>
> > Any thoughts?
>
> I presume the "lookup" works on the basis of a relationship. It would
> help to diagnose the trouble if you would describe the relationship
> structure and the give the definition of the fields involved.
>
> --
> For email, change <fake> to <earthlink>
> Bill Collins

Thanks Bill,

I discovered the problem. When I imported the citycounty information
from the csv file, apparently it also copied a blank space or return
character. When I deleted the "invisible" character, the lookup
worked properly.