1 Reply Latest reply on Dec 9, 2011 12:29 PM by philmodjunk

    Field Unrelated Table lookups

    DavidSimmons

      Title

      Field Unrelated Table lookups

      Post

      How can I do a field lookup to an unrelated table? I would like to pass a value from the current table as a key to the lookup table return  some field value.

        • 1. Re: Field Unrelated Table lookups
          philmodjunk

          Why would this be an unrelated table? If you are passing a vlaue from the current table as a key for the lookup, why not define a relationship based on the field storing that value?

          It is also possible to use set variable to copy the value from the table's field into a variable, switch to a layout based on the other table and use it to perform a find. Set variable can then be used to bring a value thus looked up back to the original layout and it's table.

          But why go to all that trouble just to avoid defining a relationship to the look up table?