Limit to length of Calculated fields in relations?

[Scott Pon]

Environment:

Filemaker 5 Server

Filemaker 5 Pro

WIndows 2000 server

Windows 98 & Windows 2000

I have a purchase order file and a sales order file.

Purchase order field names

Company Code - Text

Company - text

PONum - Text

CodePOKey - calculated(text): Company Code & "-" & PONum

Sales Order field Names

Company Code - Text

Company - text

PONum - Text

CodePOKey - calculated(text): Company Code & "-" & PONum

Amount - Number

Relationship:

POdb:codePOkey = OrdDB:CodePOkey

The Customer code is 10 Characters long. the POnum can be any number of characters long. Is there a limit on how long this compairison can be? I have attached 2 files to demonstrate what I'm trying to prove.

The quick explaination is:

in POdb,

record: INTER-TX01-123-00000000544 and record: INTER-TX01-123-00000000924 both show the same Sales Orders, even though the POs are different.

How many characters does FM compare? It obviously doesn't compare the entire string to the entire string.

Is this fixed in Filemaker 7?? (i'm pushing my company to move to this upgrade)

I am posting a picture of what I mean. thanks.

[BobWeaver]

If I recall correctly, version 5 indexes 20 characters per word, up to a total of 60 characters. So, you could try breaking the ID number with a space somewhere near the middle.

[Scott Pon]

I tried this out and I think that is it! I only tested on my test files. So I will impliment this into the official copy and make sure it works. It worked in my test file!

Thanks.