Messed up Text relationship

[ayrobotech]

This doesn't make any sense to me at all and I've been building filemaker databases for a long time. Anyways, I have two tables. Lets call one Company and the other Patient. Within both databases they have a field called "code". So I set them both up as text field. In the relationship I drag CODE in COmpany to CODE in Patient.

I set up a portal in a form for Patient. When I see a person with CODE of B001, in the portal for Company I'm getting:

A001

B001

CD01

D001

and so on

So why isn't the text of "B001" ONLY mapping to the text in the other table of "B001"??? Why is it getting the A001 and so on? I could see this happening if they were NUMBER fields, but they are not, they are text. I have verified and re-verified this...

[ayrobotech]

Nevermind. It was linked to the wrong table which had a number value.

Another question: Is there any way to link two text fields and have it ignore the dead white space? I'm doing an import that includes white space, so instead of just B001 it is "B001 ". Right now I write parsers to cut off the white space, but it would be easier and take less time if the relationship ignored dead space.

[Vaughan]

Look into the Trim4() custom function at Brian Dunning's web site.