AnsweredAssumed Answered

Lookup Table

Question asked by ahcho on Apr 30, 2012
Latest reply on May 1, 2012 by philmodjunk

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

Outcomes