Multiple Relationships Issue

[Reynaldo]

Hello Everyone,

I'm new to FM Pro 10 and I'm trying to create a proper relational database.

My problem is that in the KeyData Table, I can pull up the room, but I can’t pull up the Suite. It should work like this:

KeyData [RoomID] -> Rooms[suiteID] -> Suites[suite] and that path should return the Suite Name in the KeyData table, but so far its only returning blanks for suites. I think I've read that FM Pro has problems grabbing field values from chained tables, is this true? and if so is there a work around? Thanks for any input.

[IdealData]

Can you post the calculation?

[Fenton]

It sure looks right. I would look at the data in the Suite ID, on one that you think should match.