Multiple Relationships Issue
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.