AnsweredAssumed Answered

Creating relationships among tables

Question asked by JungleJane on Oct 26, 2009
Latest reply on Oct 26, 2009 by philmodjunk

Title

Creating relationships among tables

Post

We use FMPro 9.0v1, in part, to create itineraries. I am trying to create a relationship between the fields in the table "Hotels" and the fields in "Travel_Lodging" so that when I go to an individual itinerary, a drop down menu of hotels appears when I tab to hotel name. The same thing should happen for phone, address, and city. I have gone to manage database and clicked on tables, relationships, and fields with no luck. Most recently I have received the error message "There are no fields that look up the values on the field "Hotel Phone," "Hotel Name," etc. 

 

In the process of this, I have created Travel_Lodging 2, 3, 4 and Hotels 2, 3, 4.  

 

Can anyone help me to create the relationships so that when I go to the different fields on "Travel Lodging," my data will appear?

Outcomes