Bad relationship

[pw]

I have a raltionship that counts the number of pages with certain statuses. Similar to a cross tab report in the other database (excel) lol

Job Table and Page Status Table.

When I view one particular job the count does not appear to tabulate at all. Although the other jobs that use that same relationship tabulates fine.

I've tried creating another relationship think the relationship is currupt and also creating a new record with no luck.

I've changed the layout to show the related records in a portal with no records showing up for the one job, but the correct records on the other jobs.

I'v ealso copied the key field and did a search in the related table in the proper realted field and the found set does match the total that should appear.

I'm at a lost what might cause this issue.

[jteich]

If you use text fields as keys on both sides of the relationship an additional space in the key field makes the relationship invalid.

This is the reason why I always use number fields as keys.

-jens

[pw]

I found the answer. This system takes data from another system using mysql. The customer started the job as one name and then changed the name taking away dashes in between some words. (Thus the solving the mystery of why it works for some records and not others) When you do a find from the data in the related field it found those record. thus I thought the relationship should be good.

But in FM if you do a find for "This - Word", or "This Word" it will find it.

I normally don't like to use text for relationships, but sometimes it is necessary.

thanks for you're feedback, It help me look a little closer at the relationship.