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?
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.