Stumped: Disappearing Related Value...

[stefwef]

I have about 10 related tables all set up the same way, and one of them is not working when all the other ones are working fine. I am totally stumped. I can't just create a new table from scratch as this particular table is referenced all over the place.(I had created it earlier and decided to change the way it is related to match those other tables that work fine).

What is happening: when I type entry into related field, the value disappears as soon as I click off the field. If I create a calculation = that related value, it shows... However, "go to related records" does nothing, so clearly the relationship is "broken" in that direction.

When I go to the related table, the value is there, and all the key fields (3 of them) have entered correctly. In fact, in this table I see info from the other table. Hence the relationship is at least working in opposite direction.

I am totally stumped. Is this some weird indexing issue? How could I have so many identical relationships and for some reason this one does not work?

Edited October 27, 2010 by Guest
Removed Shouting.

[bruceR]

Best to post a copy of your file. You could be doing anything.

[Vaughan]

Check that the field type (text, number) is the same at both ends of the relationship. My guess is that it is set to number when it should be text.

Also check whether the relationship has a sort defined, and check that all the fields in the sort are valid: my other guess is that one or more will say "".

[stefwef]

Wow - you were right! It was a field type issue (num = text). Man, I was going bananas here. Thank you!

[Vaughan]

Yup, I've got the t-shirt for that one. :P