September 15, 201213 yr Newbies So I have a portal, and I am using a tiered group of conditional value lists to populate some the field data (This works). The problem I am having is when I get to the last drop down and make a selection, I would like that last selection to populate a merge field with data. This data is located in the same table as the last drop down. For example: The last selection is part number and based on the part number, I want to display a description of that part. Part number and part description reside in the same table but neither one of them are in the table the portal is based from. How should I approach this? Do I use lookup fields in the table the portal is based on? Do I add a calculated column in the table the portal is based on? Do I do a script to capture the last value and use that as the basis to populate a merge variable? Can I just do this with relationships somehow? I am really kind of stuck on this one and would appreciate any help.
September 28, 201213 yr Here is a really simple sample of just the relationship and fields/portal. Portal Display.zip
Create an account or sign in to comment