I have been working with FM10 for a few weeks ow. I have one field that look up from another table: Item name is the match and item value is the copied value. It worked perfectly, but then I must have changed something because now the look up only works sporadiacally. And also, sometimes the look up value doesn't appear, but the calculation using that value does. What in the world have I done to shoot myself in the foot? I'm sure it's something simple I'm just not seeing.
It will be a problem in how you setup the Lookup or else the relationship.
I looked at your file and could only log in as a guest, which did not have permission to Manage the Database and see the field and relationship in question.