AnsweredAssumed Answered

Multiple Relationships Issue

Question asked by carabalb on Mar 17, 2010
Latest reply on Mar 17, 2010 by philmodjunk

Title

Multiple Relationships Issue

Post

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.

 



database

Outcomes