1 Reply Latest reply on May 1, 2012 10:44 AM by philmodjunk

    Lookup Table

    ahcho

      Title

      Lookup Table

      Post

      Hello!

      I am having trouble with a lookup-type functionality with my layout. The image shows the current relationship setup.

      What I want to accomplish is to create a portal with 2 fields called Name and Value and a button with a question mark. The layout is based the table OliveOils.

      Name - comes from the table OliveOilCharacteristics

      Value - comes from the table OliveOilCharacteristics

      ? button - comes from OliveOilProperties 'Description' in a custom dialog box.

      I have not any success with the "? button". I have tried the function Lookup(OliveOilProperties) but I don't get anything. Is there a simpler method to address this before using a script?

      Aaron

      Relationships.jpg

        • 1. Re: Lookup Table
          philmodjunk

          The simplest approach would be to make your portal to OliveOilCharacteristics wide enough to include the description field from OlivOilProperties. Instead of using a script with a custom dialog, you just view/edit the description from the related properties table directly in the portal row.