I have 4 tables. One table contains a list of Hotels each with a unique ID, the second contains a list of room types also with unique IDs and the third contains a record for each combination; the room types being used by many different hotels. The Hotels table does not contain a link to the Room_types table nor vice versa and the Assignment file does not contain the hotel or the room-type description, just their ID#s.
In the fourth table (Reservations), I have a field for the Hotel which contains all the values from the Hotels file. I have a field for the Room-type which should contain a list of all the related values. There is a relationship from Reservations to Assignment using the Hotel_ID and another from Assigment to Room-Types using the RoomType ID.
In the value list (for Room-Types) I have Related Values selected and in the first pop-up have the relationship Reservations to Assignments. In the second opo-up I have the relationship Assignments to Room Types which I would have thought would give me (in the room_type field) a list of all the possible room types for the selected hotel. It does not and just gives me an empty list.
What am I doing wrong? Many thanks.