Lookups not happening like they did in v5.5

[Philby]

I have an invoice type file with a customer code field that is related to a customer file.

When you enter the customer code it should lookup the customer info and put it in the invoice.

Entering the code doesn't seem to generate an automatic lookup in the form.

In V5.5, everything worked perfectly...

Any ideas on what may be happening or any workarounds?

Thank you,

[Ender]

Try putting a related Customer field on the layout. Does it show data? Do you have mulitple Table Occurances of Customer on the relationship graph? Maybe your lookup is based on the wrong TO.

[Philby]

I do have multiple occurances of the customer table.

One is based on billing address the other is based on shipping address.

Does this cause problems?

[Ender]

So is there one based on Customer Code? There would need to be if you are using that field to trigger a lookup.

[Philby]

After a couple of hours of searching I found out that for some reason I have

trailing spaces in the CustomerID field of the Customer table.

I'm using ODBC to get the Customer info from another database.

FM5.5 will disregard the trailing spaces and come up with a match.

FM7 will treat treat ABC and ABC_ as two different results and won't come up with a match.

I created another field that is a trimmed CustomerID field and I'm using this in my relationship.

Now everything works fine....

Thank you,