1 Reply Latest reply on Apr 22, 2015 8:28 AM by philmodjunk

    Populating a drop down menu with text fields from another layout

    AlanMassey

      Title

      Populating a drop down menu with text fields from another layout

      Post

      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,

      Alan

        • 1. Re: Populating a drop down menu with text fields from another layout
          philmodjunk

          There are two parts to your question: a) defining a relationship that matches the records in one table to records in another table by room. A room name field could be used, but a room ID field is a slightly better option. (If you remodel or redecorate and your rooms are given new names, you don't want changing a room's name to disconnect it from related records in another table.)

          b) is the main part of your question, setting up a value list of those room designations so that you can select a room for a record in your second table in order to link it to a room record in your table of rooms.

          for b) Open up manage | Value lists and create a new value list. Select the "use values from field" option and select your table of rooms from the drop down list in the next dialog box to appear. If you stay with room names, you need only click to select the room name field from the list of room names that appears below the drop down. If you want to associate a room name with a room ID, select the room ID field in the first list, then select "also use values from" and then select the room name field from the second list. This gives you a two column list where you can select a room by name, but enter the room's ID into your field in order to link it by Room ID to a record in the rooms table.