Creating relationships among tables
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?