1 Reply Latest reply on Jan 20, 2012 2:10 PM by philmodjunk

    Related file lookup

    cowtrax

      Title

      Related file lookup

      Post

      Is it possible to "call" a Table View of a file (table 2) from one layout (table 1), then select a record from that view and return it to the calling layout and place one of the fields (from table 2) into a field in table 1?  I am trying to have a more flexible lookup of data from one file and placing the key from the lookup file (table 2) into the foreign key of the calling layout.  Hope that makes sense.  I am just trying to get around the limitations of the standard file lookup via value lists.

      Thanks.

        • 1. Re: Related file lookup
          philmodjunk

          "file" lookup or Record look up?

          One common way to pass data from one layout to another is with variables--provided to keep the process all in one file.

          Usually, you use a list view instead of a table view for this as it's easier to set up all the fields in the row as a button that way. In table view you ahve to use script triggers to respond to a click on the row of data.

          Either way, the script might look like this:

          Set Variable [$ID ; CurrentTable::PrimaryKey ]
          Go to Layout [//layout for other table]
          Set Field [OtherTable::Field ; $ID]