rateBuilder, Locations, roomTypes and roomIDs.
The relationships are
1. ratebuilder_to_roomIDs using field locationID
2. roomIDs_to_roomTypes using field roomtypeID
A value list displays all of the location names (from the Locations table) but returns the locationID. The roomtypeID field should then display all of the related records from the ratebuilder_to_roomIDs relationship but comes up blank! Additionally what I really want, in the roomtypeID field is to display the names from the roomTypes table but return the roomtypeID but again, if I select the relationship roomIDs_to_roomTypes, the correct fields appear for selection but nothing appears in the value list. Both values lists are formatted as comboboxes and scrolling has been disabled.
The roomTypes valus list is set to use Database Values and Related Values. The left side of the Related Values is set to use the relationship
ratebuilder_to_roomIDs
The right side is set to use the relationship
roomIDs_to_roomTypes
Obviously I am doing something wrong but can't see it. TIA[/quote]