Populating a drop down menu with text fields from another layout
I'm working on a FM project where I want to be able to have the "Room Name" fields from records in one layout to appear in a drop down field in another layout. Each record in the first layout gets an individual room name which is just text, but in the second layout I want to be able to associate items with rooms (records) from the first layout.
As I'm typing this I feel like I'm just confusing the matter more. Let me know if there is anything that needs clarification...
Thanks in advance,